GPBR_RC_TER_VOL(SQL Table) |
Index Back |
|---|---|
Termination Letters BRAAll Termination Letters BRA |
| # | 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 | RUN_CNTL_ID |
Character(30) | VARCHAR2(30) NOT NULL | Run Control ID |
| 3 | COMPANY | Character(3) | VARCHAR2(3) NOT NULL |
Company
Prompt Table: COMPANY_TBL |
| 4 | DEPTID | Character(10) | VARCHAR2(10) NOT NULL | Department |
| 5 | SETID | Character(5) | VARCHAR2(5) NOT NULL | SetID |
| 6 | ESTABID | Character(12) | VARCHAR2(12) NOT NULL | Establishment ID |
| 7 | GPBR_HRPERSON | Character(10) | VARCHAR2(10) NOT NULL |
HR Person
Prompt Table: PERS_SRCH_GBL |
| 8 | BEGIN_DT | Date(10) | DATE NOT NULL | Begin Date |
| 9 | END_DT | Date(10) | DATE NOT NULL | end date |
| 10 | GPBR_TERM_NOTIF | Date(10) | DATE | Termination Notification |
| 11 | GPBR_LIST_OPTION | Character(1) | VARCHAR2(1) NOT NULL |
List Option
Brazil Run Control
1=All Establishments & Employees 2=Select Establishment ID 3=Select Employees 4=Select Group ID 5=Select Pay Group 6=All Employees 7=Select Department ID Default Value: 2 |
| 12 | GPBR_RPT_NAME | Character(1) | VARCHAR2(1) NOT NULL |
Report type/name
Brazil Run Control
1=Voluntary Report 2=Prior Notification Report 3=Employee Fair Cause Report 4=Notice of Dismissal Default Value: 1 |
| 13 | WORK_SCHEDULE | Character(7) | VARCHAR2(7) NOT NULL | Work Schedule |
| 14 | INTERVW_DT | Date(10) | DATE NOT NULL |
Interview date
Default Value: %DATE |
| 15 | GPBR_TIME | Time(15) | TIMESTAMP |
Cumulative Edit Time
Default Value: %TIME |
| 16 | GPBR_WHITNESS1 | Character(10) | VARCHAR2(10) NOT NULL |
Whitness one
Prompt Table: PERS_SRCH_GBL |
| 17 | GPBR_WHITNESS2 | Character(10) | VARCHAR2(10) NOT NULL |
Whitness two
Prompt Table: PERS_SRCH_GBL |