UPG_ACTRSN_TMP

(SQL Table)
Index Back

Upgrade Temp Table

used to fix a paren/child issue (ACTN_REASON_TBL, ACTN_REASON_BRA, ACT_RSN_TBL_ESP)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 ACTION Character(3) VARCHAR2(3) NOT NULL Action
2 ACTION_REASON Character(3) VARCHAR2(3) NOT NULL Reason Code
3 CAGED_REASON_BRA Character(2) VARCHAR2(2) NOT NULL CAGED Action Reason Code Brazil
00=00-Not Applicable
10=10-Hire - First Job
20=20-Hire - with Previous Job
25=25-Temporary Contract
31=31-Dismissal w/o fair cause
32=32-Dismissal with fair cause
35=35-Reintegration
40=40-Voluntary Resignation
43=43-End of Fixed Period
45=45-End of Fixed-Term Contract
50=50-Retired
60=60-Death
70=70-Transfer - Hire
80=80-Transfer - Termination
90=90-Term by Common Agreement
4 RAIS_REASON_BRA Character(2) VARCHAR2(2) NOT NULL RAIS Action / Reason
5 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
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
6 AFI_SS_ACTION_ESP Character(3) VARCHAR2(3) NOT NULL Actions to report to the Social Security through the affiliation report