UPG_ACTRSN_TMP(SQL Table) |
Index Back |
---|---|
Upgrade Temp Tableused 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 |