GPBR_LEAVE_PROG(SQL Table) |
Index Back |
---|---|
Leave Credit RecordLeave Program Record |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | EMPLID | Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
2 | EMPL_RCD | Number(3,0) | SMALLINT NOT NULL | Empl Record |
3 | BEGIN_DT | Date(10) | DATE NOT NULL | Begin Date |
4 | END_DATE | Date(10) | DATE NOT NULL | End Date |
5 | ABS_BGN_DT | Date(10) | DATE NOT NULL | Absence Begin Date |
6 | ABS_END_DT | Date(10) | DATE | Absence End Date |
7 | DAYS | Number(3,0) | SMALLINT NOT NULL | Days |
8 | GPBR_13TH_ADVANCE | Number(1,0) | SMALLINT NOT NULL |
Advance payment 13th Month
1/0 Table Edit (1=True, 0=False) |
9 | GPBR_LEAVE_STATUS | Character(2) | VARCHAR2(2) NOT NULL |
Leave Status
01=Programmed 03=Calculated 04=Confirmed 05=Cancelled 06=Closed Default Value: 01 |
10 | GPBR_PROG_LEAVE_ID | Character(2) | VARCHAR2(2) NOT NULL |
Program Identifier
01=Manual 02=Collective Default Value: 01 |
11 | GPBR_PAY_CREDIT | Number(1,0) | SMALLINT NOT NULL |
Y N field Pay Credit for Programed Leaves
1/0 Table Edit (1=True, 0=False) |
12 | GPBR_CREDIT_DAYS | Number(3,0) | SMALLINT NOT NULL | Credit Days |
13 | GPBR_CRED_BGN_DT | Date(10) | DATE | Credit Begin Date -- Vacations Brazil |
14 | GPBR_CRED_END_DT | Date(10) | DATE | Credit End Date Vacations Brazil |
15 | GPBR_MASS_ABS_ID | Character(10) | VARCHAR2(10) NOT NULL | Mass Vacation ID Brazil |