| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 SOCS_AUTH_KEY_ESP |
Character(8) |
VARCHAR2(8) NOT NULL |
Authorization Key
|
| 2 |
GPES_FILE_DATE |
Date(10) |
DATE |
File Date
|
| 3 |
SSN_EMPLOYER |
Character(13) |
VARCHAR2(13) NOT NULL |
Employer Social Security number
|
| 4 |
EMPLID |
Character(11) |
VARCHAR2(11) NOT NULL |
Employee ID
|
| 5 |
EMPL_RCD |
Number(3,0) |
SMALLINT NOT NULL |
Empl Record
|
| 6 |
GPES_FIE_SEGMENT |
Character(3) |
VARCHAR2(3) NOT NULL |
FIE Segment
AYN=AYN - Employee Name
CIT=CIT - Continuation IT
DAF=DAF - Affiliation Data
DIP=DIP - Permanent Disb Data
DIT=DIT - Temporary Disb Data
DOP=DOP - Other Subsidy Data
EMP=EMP - Company Identification
ETF=ETF - Final Segment
ETI=ETI - File Identification
IT2=IT2 - Other IT Data 2
ITD=ITD - Disability Direct Pay
JUB=JUB - Retirement Data
NAC=NAC - Birth
OIT=OIT - Other IT Data
RZS=RZS - Company Name
TRA=TRA - Employee Identification
|
| 7 |
GPES_FIELD_NUM |
Number(6,0) |
INTEGER NOT NULL |
Field number/sequence within the record layout.
|
| 8 |
GPES_ABS_BGNDT |
Date(10) |
DATE |
Absence begin date
|
| 9 |
GPES_SUBSIDY_TYPE |
Character(3) |
VARCHAR2(3) NOT NULL |
Subsidy type
DIP=DIP - Permanent Disb Data
DIT=DIT - Temporary Disb Data
DOP=DOP - Other Subsidy Data
ITD=ITD - Disability Direct Pay
JUB=JUB - Retirement Data
NAC=NAC - Birth
OIT=OIT - Other IT Data
|
| 10 |
GPES_FLD_LBL |
Character(60) |
VARCHAR2(60) NOT NULL |
Flat file field label
|
| 11 |
GPES_FLD_VAL_CHR |
Character(30) |
VARCHAR2(30) NOT NULL |
Value as it comes from the FIE flat file Field (always alphanumeric).
|
| 12 |
GPES_FLD_VAL_NUM |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
Numeric field value
|
| 13 |
GPES_FLD_VAL_DT |
Date(10) |
DATE |
Date Field value
|
| 14 |
CREATEDTTM |
DateTime(26) |
TIMESTAMP |
DateTime of Query Creation
|