CLAIMIDPLAN_TYPEBENEFIT_PLANFORM_IDPAYCHECK_NBRCHECK_DTFSA_CLAIM_PAYMT(SQL View) |
Index Back |
|---|---|
FSA Claim PaymentsFSA_CLAIM_PAYMT is a view of claims payment information. It contains the same data found on the FSA_PAYMT_CLAIM table. However, it is used by the FSA Claim Details panel, which is more claims specific. |
| Select A.ClaimID ,A.Plan_Type ,A.Benefit_Plan ,A.Form_ID ,A.PAYCHECK_NBR ,A.Check_Dt ,A.FSA_Claim_Amt_Pd FROM PS_FSA_PAYMT_CLAIM A |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | CLAIMID |
Character(8) | VARCHAR2(8) NOT NULL | Claim ID |
| 2 | PLAN_TYPE |
Character(2) | VARCHAR2(2) NOT NULL | Identifies a category of benefit plan, such as Medical, Dental, and Life (Insurance). A set of plan type codes, as well as rules for creating new codes, is provided by PeopleSoft. Plan Type codes determine how the system processes and defines eligibility for the various benefit plans. |
| 3 | BENEFIT_PLAN |
Character(6) | VARCHAR2(6) NOT NULL | Benefit Plan |
| 4 | FORM_ID |
Character(6) | VARCHAR2(6) NOT NULL | Form Identification |
| 5 | PAYCHECK_NBR |
Number(15,0) | DECIMAL(15) NOT NULL | Paycheck number. |
| 6 | CHECK_DT |
Date(10) | DATE | Check date. |
| 7 | FSA_CLAIM_AMT_PD | Number(8,2) | DECIMAL(7,2) NOT NULL | Claim Amount Paid |