AFI_DATA_SRCH

(SQL View)
 Index Back

AFI Data for Employees

AFI Data for Employees

SELECT DISTINCT %Sql(SCRTY_SEL_PKEY, OPR,SEC) , AFI.EFFDT , AFI.EFFSEQ , AFI.AFI_SS_ACTION_ESP , AFI.AFI_EE_STATUS_ESP , AFI.TIME_STAMP_ESP , AFI.AFI_REPORTBY_ESP , AFI.AFI_NODE_STATS_ESP , AFI.AFI_FILE_NAME_ESP , AFI.DEPTID , AFI.COMPANY , AFI.SSN_EMPLOYER FROM %Sql(SCRTY_PER_FROM) , PS_AFI_DATA_ESP AFI WHERE %Sql(SCRTY_NO_APPT1) AND %Sql(SCRTY_WHERE, 'PPLJOB') AND SEC.EMPLID = AFI.EMPLID AND SEC.EMPL_RCD = AFI.EMPL_RCD

# 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 Rcd Nbr
5 ACTION_DT Date(10) DATE Action Date
6 EFFSEQ Number(3,0) SMALLINT NOT NULL Effective Sequence
7 AFI_SS_ACTION_ESP Character(3) VARCHAR2(3) NOT NULL Actions to report to the Social Security through the affiliation report
8 AFI_EE_STATUS_ESP Character(2) VARCHAR2(2) NOT NULL Social Security AFI Employee Status
01=Hire
51=Voluntary / Resignation
53=Individual Disciplinary Dismis
54=Non Voluntary Termination
55=Termination by Takeover
56=Termination by Death
58=Termination by Retirement
61=Termination by Military Serv
61=Termination by Military Serv
63=Termination by Voluntary Leave
65=Termination by End of IT
67=Termination by Seasonal Layoff
68=Termination by Maternity
69=Termination by ERE Suspension
73=Termination by Dependent Care
74=Other Term. by Suspension
76=Term by Domestic Violence
77=Mass dismissal
80=Susp by Domestic Violence
85=End of Test Period
91=TER Objective Reasons. Worker
92=TER Objective Reason. Company
93=TER End of Contract
94=Inactivity in Permanent Interm
99=Other Termination Reasons
9 TIME_STAMP_ESP DateTime(26) TIMESTAMP Time Stamp
10 AFI_REPORTBY_ESP Character(1) VARCHAR2(1) NOT NULL Node Status
0=AFI File
1=On Line
11 AFI_NODE_STATS_ESP Character(1) VARCHAR2(1) NOT NULL Node Status
0=AFI Sent Confirmed
1=Included in AFI
2=Not Communicated
12 AFI_FILE_NAME_ESP Character(20) VARCHAR2(20) NOT NULL Social Security affiliation report file name
13 DEPARTMENT Character(10) VARCHAR2(10) NOT NULL Department
14 COMPANY Character(3) VARCHAR2(3) NOT NULL Company
15 SSN_EMPLOYER Character(13) VARCHAR2(13) NOT NULL Employer Social Security number