GPES_CRT_VR_RV2(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 | SLICE_BGN_DT | Date(10) | DATE | Element Slice Begin Date |
| 2 | SLICE_END_DT | Date(10) | DATE | Element Slice End Date |
| 3 | GPES_CRT_SLC_BG_DT | Date(10) | DATE | Social Security calculation slice begin date |
| 4 | GPES_CRT_SLC_EN_DT | Date(10) | DATE | Social Security calculation slice end date |
| 5 | SOC_SEC_WRK_GRP_CD | Character(2) | VARCHAR2(2) NOT NULL |
Social Security Work Group
01=01-Engineers 02=02-Technicals 03=03-Administrative 04=04-Assistants 05=05-White Collar 06=06-Subordinates 07=07-Administrative assistants 08=08-1st and 2nd degree 09=09-3rd degree 10=10-Over 18 years 11=11-Under 18 years |
| 6 | CONTRACT_TYPE | Character(3) | VARCHAR2(3) NOT NULL | Contract Type |
| 7 | PART_TIME_PERC_ESP | Number(3,0) | SMALLINT NOT NULL | Percentage of Part Time |
| 8 | INDSTRY_CD_ESP | Character(5) | VARCHAR2(5) NOT NULL | Industry Activity Code |
| 9 | SOC_SEC_RISK_CODE | Character(3) | VARCHAR2(3) NOT NULL | Social Security Risk Code |
| 10 | GPES_CRT_STAT_VAL | Character(1) | VARCHAR2(1) NOT NULL |
CRET@ Social Security calculation verification status.
0=Matched 1=Mismatch 3=Not Verified |
| 11 | GPES_CRT_STAT_TRM | Character(1) | VARCHAR2(1) NOT NULL |
CRET@ Social Security employee slice verification status.
0=Matched 1=Mismatch 3=Not Verified |