AFI_FILE_VW_ESP (SQL View)	Index Back
AFI Data for Employees AFI Data for Employees

AFI_FILE_VW_ESP

(SQL View)

AFI Data for Employees

SELECT DISTINCT AFI_FILE_NAME_ESP , AFI_REPORTBY_ESP FROM PS_AFI_DATA_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

#	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