ACTN_REASON_BRA(SQL Table) |
Index Back |
|---|---|
Action Reason Asociate RecordAction Reason Asociate Record Brazil |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  ACTION |
Character(3) | VARCHAR2(3) NOT NULL |
Action
Prompt Table: ACTION_TBL |
| 2 | ACTION_REASON |
Character(3) | VARCHAR2(3) NOT NULL |
Reason Code
Prompt Table: ACTN_REASON_TBL |
| 3 | EFFDT |
Date(10) | DATE NOT NULL |
Effective Date
Default Value: %date |
| 4 | 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 Default Value: 00 |
| 5 | RAIS_REASON_BRA | Character(2) | VARCHAR2(2) NOT NULL |
RAIS Action / Reason
Default Value: 0 |