GPES_CRT_VR_REV(SQL Table) |
Index Back |
|---|---|
Verification comparisionDummy record to show Cret@ validation diferences in the review page |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | GPES_CRT_CODE | Character(3) | VARCHAR2(3) NOT NULL | Code for Creta reporting |
| 2 | GPES_SSTC_CT_ER | Signed Number(15,2) | DECIMAL(13,2) NOT NULL | Employer Social Security Contributions. This field is used to populate the GP Write Array, which is used to generate the FAN File. |
| 3 | GPES_SSTC_CT_EE | Signed Number(17,2) | DECIMAL(15,2) NOT NULL | Employee Social Security Contributions. This field is used to populate the GP Write Array, which is used to generate the FAN File. |
| 4 | GPES_CRT_SS_CT_EE | Signed Number(17,2) | DECIMAL(15,2) NOT NULL | CRET@ Employee contribution. |
| 5 | GPES_CRT_SS_CT_ER | Signed Number(15,2) | DECIMAL(13,2) NOT NULL | CRET@ Employer contribution. |
| 6 | GPES_SSTC_CT_TT | Signed Number(16,2) | DECIMAL(14,2) NOT NULL | Employer Social Security Total Contributions. |
| 7 | GPES_CRT_STAT_VAL | Character(1) | VARCHAR2(1) NOT NULL |
CRET@ Social Security calculation verification status.
0=Matched 1=Mismatch 3=Not Verified |