AFI_FILE_VW_ESP

(SQL View)
Index Back

Search VW for AFI Files - ESP

Search VW for AFI Files - ESP

SELECT DISTINCT AFI_FILE_NAME_ESP , AFI_REPORTBY_ESP FROM PS_WKF_CNT_INC_ESP WHERE AFI_FILE_NAME_ESP <> ' '

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 AFI_FILE_NAME_ESP Character(20) VARCHAR2(20) NOT NULL Social Security affiliation report file name
2 AFI_REPORTBY_ESP Character(1) VARCHAR2(1) NOT NULL Node Status
0=AFI File
1=On Line