GPES_FILE_FLDVW(SQL View) |
Index Back |
---|---|
FIE File Fields ViewThis view retrieves the fields by subsidy type, from the setup. |
SELECT B.GPES_SUBSIDY_TYPE , A.GPES_FIELD_NUM , A.GPES_FIELD_I , A.GPES_FIELD_L , A.GPES_FLD_TYP , A.GPES_FLD_DEC , A.GPES_FLD_FMT , A.FIELDNAME , B.GPES_FIE_SEGMENT %Concat ' - ' %Concat A.GPES_FLD_LBL , B.GPES_FIE_SEGMENT , A.RECNAME_EDIT , A.FIELDNAME_KEY1 FROM PS_GPES_FILE_FLD A , PS_GPES_FIE_SEG_VW B WHERE A.GPES_FILE_CD = 'FIE' AND A.GPES_FIELD_I <> 1 AND %Substring(A.GPES_REC_TYPE,1,3) = B.GPES_FIE_SEGMENT |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | 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 |
2 | GPES_FIELD_NUM | Number(6,0) | INTEGER NOT NULL | Field number/sequence within the record layout. |
3 | GPES_FIELD_I | Number(4,0) | SMALLINT NOT NULL | Flat file field beginnig position |
4 | GPES_FIELD_L | Number(3,0) | SMALLINT NOT NULL | Flat file field length |
5 | GPES_FLD_TYP | Character(1) | VARCHAR2(1) NOT NULL |
Flat file field type
A=Alphabetic D=Date N=Numeric X=Alphanumeric |
6 | GPES_FLD_DEC | Character(1) | VARCHAR2(1) NOT NULL | Flat file field decimal positions |
7 | GPES_FLD_FMT | Character(4) | VARCHAR2(4) NOT NULL |
Flat file field format for date type fields
DD=Day DY2=DDMMYY DY2-=DD-MM-YY DY2/=DD/MM/YY DY4=DDMMYYYY DY4-=DD-MM-YYYY DY4/=DD/MM/YYYY MM=Month MY2=MMDDYY MY2-=MM-DD-YY MY2/=MM/DD/YY MY4=MMDDYYYY MY4-=MM-DD-YYYY MY4/=MM/DD/YYYY NONE=None Y2=YYMMDD Y2-=YY-MM-DD Y2/=YY/MM/DD Y4=YYYYMMDD Y4-=YYYY-MM-DD Y4/=YYYY/MM/DD YY=Year (2) |
8 | FIELDNAME | Character(18) | VARCHAR2(18) NOT NULL |
Field Name (see PSDBFIELD).
Prompt Table: PSRECFIELDALL |
9 | GPES_FLD_LBL | Character(60) | VARCHAR2(60) NOT NULL | Flat file field label |
10 | 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 |
11 | RECNAME_EDIT | Character(15) | VARCHAR2(15) NOT NULL |
Edit Table for Record
Prompt Table: %EDITTABLE |
12 | FIELDNAME_KEY1 | Character(18) | VARCHAR2(18) NOT NULL |
Field created for use with element packager
Prompt Table: GPES_FILE_FK1_V |