GPES_FILE_FLDVW

(SQL View)
Index Back

FIE File Fields View

This 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