GPBR_TERM_CODE0=Employee
1=Non-Employee
GPBR_TER_CD_VW(SQL View) |
Index Back |
|---|---|
eSocial Termination Code VieweSocial Termination Code View. |
| SELECT GPBR_TERM_CODE , GPBR_EMPL_CATEGRY , DESCR50 FROM %Table(GPBR_TER_CD_TBL) A WHERE %EffdtCheck(GPBR_TER_CD_TBL B, A, %CurrentDateIn) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | GPBR_TERM_CODE |
Character(2) | VARCHAR2(2) NOT NULL | eSocial:Termination Legal Code. |
| 2 | GPBR_EMPL_CATEGRY | Character(1) | VARCHAR2(1) NOT NULL |
eSocial : Employee Category.
0=Employee 1=Non-Employee |
| 3 | DESCR50 | Character(50) | VARCHAR2(50) NOT NULL | Description of length 50 |