AFI_RC_ESP(SQL Table) |
Index Back |
|---|---|
AFI Process Run Control ESPRun Control for Spanish AFI Social Security Process |
| # | 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 | RUN_CNTL_ID |
Character(30) | VARCHAR2(30) NOT NULL | Run Control ID |
| 3 | AFI_FILE_NAME_ESP | Character(20) | VARCHAR2(20) NOT NULL | Social Security affiliation report file name |
| 4 | FILE_PATH | Character(127) | VARCHAR2(127) NOT NULL | Input/Output file path |
| 5 | DATE_FROM | Date(10) | DATE | Date From |
| 6 | DATE_TO | Date(10) | DATE | Previous Period Date To |
| 7 | TEST_SS_ESP | Character(1) | VARCHAR2(1) NOT NULL |
Test
Y/N Table Edit Default Value: N |
| 8 | SOCS_AUTH_KEY_ESP | Character(8) | VARCHAR2(8) NOT NULL |
Authorization Key
Prompt Table: SOCS_SETHD_VW |
| 9 | AFI_ACT_MA_ESP | Character(1) | VARCHAR2(1) NOT NULL |
Hire flag to report to the Social Security
Y/N Table Edit Default Value: N |
| 10 | AFI_ACT_MB_ESP | Character(1) | VARCHAR2(1) NOT NULL |
Termination flag to report to the Social Security
Y/N Table Edit Default Value: N |
| 11 | AFI_ACT_MC_ESP | Character(1) | VARCHAR2(1) NOT NULL |
Change of contract flag to report to the Social Security
Y/N Table Edit Default Value: N |
| 12 | AFI_ACT_MD_ESP | Character(1) | VARCHAR2(1) NOT NULL |
Erase consolidated hiring flag to report to the Social Security
Y/N Table Edit Default Value: N |
| 13 | AFI_ACT_ME_ESP | Character(1) | VARCHAR2(1) NOT NULL |
Erase previous data flag to report to the Social Security
Y/N Table Edit Default Value: N |
| 14 | AFI_ACT_SA_ESP | Character(1) | VARCHAR2(1) NOT NULL |
Erase previous data flag to report to the Social Security
Y/N Table Edit |
| 15 | AFI_ACT_MG_ESP | Character(1) | VARCHAR2(1) NOT NULL |
Change of work group flag to report to the Social Security
Y/N Table Edit Default Value: N |
| 16 | AFI_ACT_MT_ESP | Character(1) | VARCHAR2(1) NOT NULL |
Change of risk code flag to report to the Social Security
Y/N Table Edit Default Value: N |
| 17 | AFI_ACT_ADT_ESP | Character(1) | VARCHAR2(1) NOT NULL |
Worked Days in Part Time employees flag to report to the Social Security
Y/N Table Edit |
| 18 | AFI_ACT_OTH_ESP | Character(1) | VARCHAR2(1) NOT NULL |
Worked Days in Part Time employees flag to report to the Social Security
Y/N Table Edit |