AFI_RC_OTH_ESP

(SQL Table)
Index Back

AFI RC Special Action Employee

AFI RC Special Action Employee

# 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 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

Prompt Table: EMPL_AUT_VW_ESP

4 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Record
5 AFI_SS_ACTION_ESP Character(3) VARCHAR2(3) NOT NULL Actions to report to the Social Security through the affiliation report
6 ACTION_DT Date(10) DATE Action Date
7 END_DT Date(10) DATE end date
8 AFI_PRINT_FLG_ESP Character(1) VARCHAR2(1) NOT NULL ASA Types for AFI
C=Print Resolution + IDC
I=Contribution Data Report (IDC)
N=No
S=Print Resolution

Default Value: N

9 CONTRACT_NUM Character(25) VARCHAR2(25) NOT NULL Contract Number

Prompt Table: CNT_ACTIVE_VW

10 SSN_EMPLOYER Character(13) VARCHAR2(13) NOT NULL Employer Social Security number

Prompt Table: SOCS_AFI_ESP_VW