AFI_DATA_VW_ESP(SQL View) |
Index Back |
|---|---|
AFI Data for EmployeesAFI Data for Employees |
| SELECT DISTINCT %Sql(SCRTY_SEL_PKEY, OPR,SEC) , AFI.AFI_FILE_NAME_ESP , AFI.EFFDT , AFI.CONTRACT_NUM , AFI.CNT_EVENT_ESP , AFI.CNT_EVENT_RSN_ESP , AFI.TIME_STAMP_ESP , AFI.AFI_REPORTBY_ESP , AFI.AFI_NODE_STATS_ESP FROM %Sql(SCRTY_PER_FROM) , PS_WKF_CNT_INC_ESP AFI WHERE %Sql(SCRTY_NO_APPT1) AND %Sql(SCRTY_WHERE, 'PPLJOB') AND SEC.EMPLID = AFI.EMPLID |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  OPRID |
Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 2 | ROWSECCLASS | Character(30) | VARCHAR2(30) NOT NULL | The class used to determine row level security |
| 3 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 4 | EMPL_RCD |
Number(3,0) | SMALLINT NOT NULL | Empl Record |
| 5 | AFI_FILE_NAME_ESP |
Character(20) | VARCHAR2(20) NOT NULL | Social Security affiliation report file name |
| 6 | ACTION_DT |
Date(10) | DATE | Action Date |
| 7 | CONTRACT_NUM |
Character(25) | VARCHAR2(25) NOT NULL | Contract Number |
| 8 | CNT_EVENT_ESP |
Character(3) | VARCHAR2(3) NOT NULL |
Contract Action
001=Affiliation 002=Unregister 003=Change in Contract 004=Erase Previous Data 005=Labor Agreement Communictn 006=Additional Situations 007=Worked Days Registration 008=Suspension Period 009=Additional Bases Communication |
| 9 | CNT_EVENT_RSN_ESP | Character(4) | VARCHAR2(4) NOT NULL | Contract Action |
| 10 | TIME_STAMP_ESP | DateTime(26) | TIMESTAMP | Time Stamp |
| 11 | AFI_REPORTBY_ESP | Character(1) | VARCHAR2(1) NOT NULL |
Node Status
0=AFI File 1=On Line |
| 12 | AFI_NODE_STATS_ESP | Character(1) | VARCHAR2(1) NOT NULL |
Node Status
0=AFI Sent Confirmed 1=Included in AFI 2=Not Communicated |