Claim

Introduction

This data comes from View ClaimComboQuery. View name is View_ClaimUDF. You can use View directly, and if you have access to the database, you can also access the data through the API.

CC4 Standard

Code	Name	Description	Type	Tags	ChildEntity	IsSystem	Disable
ActualAmount	Final Total	Final Total	string	Payment	ClaimQuery	True	False
ActualDropInAmount	Drop In Amount	Drop In Amount	string	Payment	ClaimQuery	True	False
ActualFamilyFee	Assigned Family Fee	The final saved value for family fee assigned for this payment.	string	Payment	ClaimQuery	True	False
ActualFTPlusAmount	FT+ Amount	FT+ Amount	string	Payment	ClaimQuery	True	False
AdjustmentAmount	Adjusted Total	Adjusted Total	string	Payment	ClaimQuery	True	False
AdjustmentComment	Adjustment Comment	Comment entered when creating an Adjustment	string	Payment	ClaimQuery	True	False
AdjustmentReason	Adjustment Reason Code	Reason entered when create an Adjustment.	string	Payment	ClaimQuery	True	False
AdjustmentRequestDate	Adjustment Request Date	Adjustment Create Time	datetime	Payment	ClaimQuery	True	False
AdjustmentSeq	Adjustment Sequence	Flag to record which Adjustment it is.	number	Payment	ClaimQuery	True	False
AdjustmentSeqNew	AdjustmentSeqNew	AdjustmentSeqNew	number	Payment	ClaimQuery	True	False
AdjustmentStatus	Adjustment Status Name	Only available when it is an Adjustment Payment	string	Payment	ClaimQuery	True	False
AdjustmentStatusId	Adjustment Status Code	Adjustment Status Code	number	Payment	ClaimQuery	True	False
Amount	Amount（Don’t Deduct Family Fee）	Total Amount without deduction of family fee.	string	Payment	ClaimQuery	True	False
CalculateUser	Calculate User ID	ID of the user who commit this payment	number	Payment	ClaimQuery	True	False
CareID	Care ID	Care ID	string	Payment	ClaimQuery	True	False
Caseid	Case ID	Case ID	number	Payment	ClaimQuery	True	False
CaseOwner	Case Specialist Name	Only used for Result
string	Payment	ClaimQuery	True	False
CaseOwnerId	Case Specialist ID	Case Specialist ID	number	Payment	ClaimQuery	True	False
ChildAge	Child Age	Child Age	string	Payment	ClaimQuery	True	False
ChildCareAmount	Child Care Amount	Items Total	string	Payment	ClaimQuery	True	False
Childid	Child ID	Child ID	number	Payment	ClaimQuery	True	False
ChildName	Child Name	Child Name	string	Payment	ClaimQuery	True	False
ClaimAmount	Amount	Adjustment = Final Total - Original Total
Child Care = Final Total	string	Payment	ClaimQuery	True	False
ClaimCode	Payment Code	Payment Code	string	Payment	ClaimQuery	True	False
Claimid	Payment ID	Payment Id	number	Payment	ClaimQuery	True	False
ClaimStatus	Payment Status Name	Only used for Result	string	Payment	ClaimQuery	True	False
ClaimStatusId	Payment Status Code	Code of all payments status, including Denied, Voided	number	Payment	ClaimQuery	True	False
ClaimType	Payment Type	Field to distinct whether payment is Adjustment or not.	number	Payment	ClaimQuery	True	False
Comment	Comment	Payment Comment	string	Payment	ClaimQuery	True	False
ContractCode	Payment Program Code	Payment Program Code	string	Payment	Payment	False	False
Contractid	Payment Program ID	Payment Program ID	number	Payment	ClaimQuery	True	False
ContractName	Payment Program Name	Only used for Result	string	Payment	ClaimQuery	True	False
CreateTime	Create Time	Create Time	datetime	Payment	ClaimQuery	True	False
CreateUserId	Create User ID	Create User ID	number	Payment	ClaimQuery	True	False
CurrentOwner	Payment Owner Name	Only used for Result	string	Payment	ClaimQuery	True	False
D001	Received Date	Received Date	datetime	Payment	ClaimQuery	True	False
DigitalSubmission	Is Digital	Whether it is a Digital Submission for this Payment. (True/False)	boolean	Payment	ClaimQuery	True	False
Disable	Disable	Disable	boolean	Payment	ClaimQuery	True	False
EndDate	Payment End Date	The care End Date within this payment period.	datetime	Payment	ClaimQuery	True	False
FamilyFee	Family Fee	The family fee value saved when first calculating the payment.	string	Payment	ClaimQuery	True	False
Familyid	Family ID	Family ID	number	Payment	ClaimQuery	True	False
FamilyName	Family Name	Family Name	string	Payment	ClaimQuery	True	False
FfCollected	Collected Family Fee	Collected Family Fee	string	Payment	ClaimQuery	True	False
FfPlan	Payment Plan	Payment Plan	boolean	Payment	ClaimQuery	True	False
FFReciptNo	Receipt#	Receipt#	string	Payment	ClaimQuery	True	False
FundingSource	Funding Source Code	Funding Source Code	string	Payment	ClaimQuery	True	False
HasAdjustment	Has Adjustment	Whether this payment has any Adjustment? (True/False) When Adjustment is Denied, this field will be False. Any other Adjustment status will be True.	boolean	Payment	ClaimQuery	True	False
HasChange	HasChange	Has Change in Payment related Care. (True/Fales)	boolean	Payment	ClaimQuery	True	False
HoldReason	Hold Reason	Hold Reason	string	Payment	ClaimQuery	True	False
InvoiceAmount	Invoice Amount	Payment Provider Invoice Total	number	Payment	Claim	False	False
IsLicense	Is License	Whether the Provider for this Payment is a License Provider. (True/False)	boolean	Payment	ClaimQuery	True	False
Issdm	Is SDM	The flag to record whether the SDM is triggered.	boolean	Payment	ClaimQuery	True	False
ManualAdjustAmount	Manual Adjust Amount	Manual Adj	string	Payment	ClaimQuery	True	False
Month	Month	Payment Month	number	Payment	ClaimQuery	True	False
OriginalAmount	Original Amount	Original Amount	string	Payment	ClaimQuery	True	False
OriginalClaimId	Original Payment ID	The original Payment ID for Adjustment payment.	int	Payment	Claim	False	False
OtherAmount	Total Other Amount	Sum of all Other Amount items	number	Payment	Claim	False	False
OtherAmountDescription	Other Amount List	Other Amount list detail	string	Payment	Claim	False	False
OtherReason	Other Return Reason	Other Return Reason content	string	Payment	Claim	False	False
OwnerId	Payment Owner ID	Payment Owner ID	number	Payment	ClaimQuery	True	False
OwnerOrgId	Payment Owner Organization ID	Payment Owner Organization ID	number	Payment	ClaimQuery	True	False
OwnerOrgName	Payment Owner Organization Name	Only used for Result	string	Payment	ClaimQuery	True	False
PayDate	Pay Date	Pay Date	datetime	Payment	ClaimQuery	True	False
PeriodEnd	Payment Period End	End Date of the Payment period.	datetime	Payment	ClaimQuery	True	False
PeriodStart	Payment Period Start	Start Date of the Payment period	datetime	Payment	ClaimQuery	True	False
ProviderFirstName	Provider First Name	Provider First Name	string	Payment	ClaimQuery	True	False
Providerid	Provider ID	Provider ID	number	Payment	ClaimQuery	True	False
ProviderLastName	Provider Last Name	Provider Last Name	string	Payment	ClaimQuery	True	False
ProviderName	Provider Name	Only used for Result	string	Payment	ClaimQuery	True	False
ProviderOwner	Provider Specialist Name	Only used for Result	string	Payment	ClaimQuery	True	False
ProviderOwnerId	Provider Specialist ID	Provider Specialist ID	number	Payment	ClaimQuery	True	False
ProviderType	Provider Type ID	Provider Type ID	number	Payment	ClaimQuery	True	False
ProviderTypeName	Provider Type Name	Only used for Result	string	Payment	ClaimQuery	True	False
QAOwner	QA Owner Name	Only used for Result	string	Payment	ClaimQuery	True	False
QAOwnerId	QA Owner ID	QA Owner ID	number	Payment	ClaimQuery	True	False
Quarter	Quarter	Quarter	number	Payment	ClaimQuery	True	False
RegistrationFee	Reg Fee (Export)	Reg Fee (Export)	string	Payment	ClaimQuery	True	False
RegistrationFee_Manual	Reg Fee (Intend)	Reg Fee (Intend)	string	Payment	ClaimQuery	True	False
ReturnReason	Return Reason Code	Return Reason Code	string	Payment	Claim	False	False
SdmComment	SDM Comment	SDM Comment	string	Payment	ClaimQuery	True	False
SdmDays	SDM Days	SDM Days	number	Payment	ClaimQuery	True	False
SpecialNeedFactor	Special Needs Adjustment	Special Needs Adjustment	string	Payment	ClaimQuery	True	False
StartDate	Payment Start Date	The care Start Date within this payment period.	datetime	Payment	ClaimQuery	True	False
Status	Payment Status Code	Code of all payments status, excluding Denied, Voided	number	Payment	ClaimQuery	True	False
SubmitDate	Submit Date	Submit Date	datetime	Payment	ClaimQuery	True	False
TotalDays	Total Days	Total Days	number	Payment	ClaimQuery	True	False
UpdateTime	Update Time	Last Updated	datetime	Payment	ClaimQuery	True	False
UpdateUserId	Update User ID	Update User ID	number	Payment	ClaimQuery	True	False
VenderNO	Vendor ID	Vendor ID field in Provider Info	string	Payment	ClaimQuery	True	False
WeekNo	WeekNo	Week of the Year	number	Payment	ClaimQuery	True	False
Year	Year	Payment Year	number	Payment	ClaimQuery	True	False