GPES_FIE_SEG_VW

(SQL View)
 Index Back

FIE File mapping view

This view is used for mapping the FIE parent segments with FIE children segments.

SELECT %Substring(XML_XLAT_VALUE,1,3) , %Substring(DESCR50,1,3) FROM PS_XML_XLATITEM WHERE XML_XLAT_CODE = 'FIE05'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 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
2 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