PI_DEFN_FILE_VW

(SQL View)
Index Back

PYI File Definition View


SELECT A.PI_SYSTEM_ID ,A.PI_FILE_ID , A.DESCRSHORT , A.PI_PROCESS_TYPE FROM PS_PI_DEFN_FILE A

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PI_SYSTEM_ID Character(4) VARCHAR2(4) NOT NULL Payroll Interface System ID

Prompt Table: PI_SYSTEM_TBL

2 PI_FILE_ID Character(6) VARCHAR2(6) NOT NULL Payroll Interface File ID
3 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description
4 PI_PROCESS_TYPE Character(1) VARCHAR2(1) NOT NULL Process Type
B=Export/Import
E=Export
I=Import

Default Value: E