this is my dataProvider Type  	Provider/Organisation ID	Provider/Organisation Name	HSCT Registration Number	Provider Registration Status Caption	Level One ID	ChildApplicationStatus	ChildActiveDate	Claim Type	ChildDateOfBirth	Does your child attend more than one eligible provider.	Claim ID	ClaimStatusCaption	ClaimStatusID	Claim Month	Claim Month 2	Claim Year	Claim Year 2	Level Two ID	Invoice Start Date	Invoice End Date	Invoice Total (before discount applied)	GSRTC Discount	New Invoice Total	Paid	Paid Date	Paid Amount	Is the claim selected for evidence?	EY Verification Completed
ABC	453454	L1	N123	Active	B1	Active	2024-08-21	Monthly	2022-11-27	1	456456	Submitted	21329	September		2024		CH1	2024-09-01	2024-09-30	11	70.2	690	Paid.	2024-09-03	70.2	Selected	Completed.
ABC	453454	L1	N124	Active	B1	Active	2024-08-21	Monthly	2022-11-27	1	768677	Submitted	78978	October		2024		CH2	2024-10-01	2024-10-31	11	70.2	690	Paid.	2024-09-26	70.2		
PQR	676575	L2	N125	Active	B2	Active	2024-08-21	Monthly	2022-11-27	1	67866		78978	October		2024		CH2	2024-10-01	2024-10-31	11	70.2	690		2024-09-26	70.2		


Add more rows to it.

This is the meaning of each column:
This worksheet includes explanation of data header for All Claims tab (Same header for the next two worksheets)	
	
1	Provider Type - Type of provider according to FSNI registration. Providers can be categorised as 1. ABC, 2. PQR
2	Provider/Organisation ID - Unique reference number used internally to identify a provider
3	Provider/Organisation Name - FSNI Registered name of the Provider
4	HSCT Registration Number - Health and Social Care Registration number. Unique registration number for providers when they register with their HSCNI trust.
5	Provider Registration Status - Current status of the Provider: The status can be Active or Active Revision Requested
6	Level One ID - Unique reference number used internally to identify a child application
7	"Child Application Status - Current status of child application. The status can be:

Draft - When a parent is creating an application for their child and stage before submitting a completed application.
Submitted - When a parent completes application, submits for the approval by the provider.
Active - When a provider approves the child application, this status allows for claims to be created and submitted for the child
Active - Revisions Requested - When the provider has requested an amendment to a child application following approval, but claims can still be created / submitted.
Closed - When provider identifies that a child is no longer attending the setting but there is still a claim which needs to be paid.
Withdrawn - When provider / parent identifies the child is no longer attending setting / no longer eligible therefore no further claims to be made."
8	Active Date - date from which child was active on GSRTC portal
9	Claim Type - Type of claim. Claim type can be a Monthly claim or an Extraordinary claim.
10	Child Date Of Birth - D.O.B of the child
11	Does your child attend more than one eligible provider - checks if the child attends more than one provider. 1 means NO, 2 means YES, and 0 means parent has not answered to this question.
12	Claim ID - each claim the provider submits is idenified using this unique reference number. This can be viewed both internally and externally.
13	"Claim Status - Current status of a claim. Claim status can be:

Draft - Every month system will automatically generate claims. This will remain as draft as long as the provider submits an eligible claim.
Submitted - Any claim provider submits with details like invoice start and end date, invoice amount etc. Amendments to invoice details not allowed aftter this stage.
Not Eligible - Claim has tried to be submitted but is missing some mandatory information. System automatically converts these type to a Not Eligible claim.
Withdrawn - Claim that is no longer needed. Could be for a various reasons, such as child has not been attending for the month, or most commonly, the child left the setting. Providers will need to contact Early Years for this to be actioned."
14	Status ID - Unique reference number used internally to identify the status of a claim. 39120 refers to a Submitted claim, 39096 refers to a Draft claim, 39168 refers to a Not Eligible claim, 39095 refers to a Withdrawn claim.
15	Claim Month - Month for which a claim is submitted
16	Claim Year - Year for which a claim is submitted.
17	Level Two ID - unique reference number used internally to identify a claim.
18	Invoice Start Date - Start date of monthly provision
19	Invoice End Date - End date of monthly provision
20	Invoice Total - Invoice amount before discount applied
21	GSRTC Discount - Original 15% GSRTC discount
22	New Invoice Total - Invoice toatal after GSRTC discount.
15	Paid - Shows if a claim is paid or not.
16	Paid Date - date on which a claim was paid.
17	Paid Amount - GSRTC discount paid to the provider. This will be same as the GSRTC discount. However may differ due to certain circumstances
18	Is the claim selected for evidence? - If the Calim is selected for Evidence, the the provider will have to uplaod an invoice as an evidence.
19	EY Verification Completed - If a claim is selcted for an evidence, Early Years staff will have to validate and approve the4 claim. When it says 'EY Review Completed.' - that merans that claim is validated.
Add thousand rows data