AFI_FILE_VW_ESP(SQL View) |
Index Back |
---|---|
Search VW for AFI Files - ESPSearch 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 |