GPBR_VACCAL_AET(SQL Table) |
Index Back |
|---|---|
Run Control VacationRun Control Vacation Entitlement process |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  PROCESS_INSTANCE |
Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 2 | AE_APPLID | Character(12) | VARCHAR2(12) NOT NULL | Program Name (see PSAEAPPLDEFN). |
| 3 | AE_SECTION | Character(8) | VARCHAR2(8) NOT NULL | Section |
| 4 | GPBR_VACN_DAYS_AP | Number(3,0) | SMALLINT NOT NULL | Vacation Days Per Acquisitive Period |
| 5 | GPBR_NEG_BALANCE | Number(1,0) | SMALLINT NOT NULL | Allow Negative Balance Vacation Parameters Brazil |
| 6 | GPBR_NEG_BAL_LIMIT | Number(2,0) | SMALLINT NOT NULL | Negative Balance Limit |
| 7 | GPBR_LEAVES_PER_AP | Number(2,0) | SMALLINT NOT NULL | Vacation Days per Acquisitive Period |
| 8 | GPBR_MIN_AGE_PART | Number(2,0) | SMALLINT NOT NULL | Minimum Age for Partiality |
| 9 | GPBR_MAX_AGE_PART | Number(2,0) | SMALLINT NOT NULL | Maximum Age for Partiality |
| 10 | GPBR_MIN_DAY_ALLOW | Number(2,0) | SMALLINT NOT NULL | Minimum Days Allowed by Leave |
| 11 | GPBR_MAX_VAC_PER | Number(2,0) | SMALLINT NOT NULL | Maximum Vacation Days per Period |
| 12 | GPBR_MAX_PCT_LEAVE | Number(6,2) | DECIMAL(5,2) NOT NULL | Maximum Percent per Leave |
| 13 | GPBR_CRE_TREATMENT | Character(2) | VARCHAR2(2) NOT NULL |
Credit Treatment
01=Starting Month 02=End of Vacations 03=Proportional Vacation Days |
| 14 | GPBR_13TH_CALC_SEP | Number(1,0) | SMALLINT NOT NULL | 13th Calculate Separately |
| 15 | GPBR_NEED_CONFIRM | Number(1,0) | SMALLINT NOT NULL | Needs Confirmation for Program |
| 16 | PIN_TAKE_NUM | Number(8,0) | INTEGER NOT NULL |
Absence Take
Prompt Table: GP_PIN_ABSTK_VW |
| 17 | GPBR_PIN_TAKEC_NUM | Number(8,0) | INTEGER NOT NULL |
Absence Take Credit Brazil
Prompt Table: GP_PIN_ABSTK_VW |
| 18 | PIN_ENT_NUM | Number(8,0) | INTEGER NOT NULL |
Element number field
Prompt Table: GP_PIN_AE5_VW |
| 19 | GPBR_CALID_VAC_ABS | Character(14) | VARCHAR2(14) NOT NULL | calendar id |
| 20 | GPBR_CALID_VAC_PAY | Character(14) | VARCHAR2(14) NOT NULL | calendar id |
| 21 | GPBR_CAL_VAC_ABS_P | Character(15) | VARCHAR2(15) NOT NULL | calendar id where clause for app engine |
| 22 | GPBR_CAL_VAC_PAY_P | Character(15) | VARCHAR2(15) NOT NULL | calendar id where clause for app engine |
| 23 | EMPLID | Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 24 | EMPL_RCD | Number(3,0) | SMALLINT NOT NULL | Empl Rcd Nbr |
| 25 | BEGIN_DT | Date(10) | DATE NOT NULL | Begin Date |
| 26 | END_DATE | Date(10) | DATE | End Date |
| 27 | ABS_BGN_DT | Date(10) | DATE NOT NULL | Absence Begin Date |
| 28 | ABS_END_DT | Date(10) | DATE | Absence End Date |
| 29 | PROGRAM_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Program Status
C=Completed F=Failed R=Running |
| 30 | GPBR_PAY_DATE | Date(10) | DATE | Payment date |
| 31 | PRD_BGN_DT | Date(10) | DATE | Period Begin Date |
| 32 | PRD_END_DT | Date(10) | DATE | Pay Period End Date |
| 33 | CAL_ID | Character(18) | VARCHAR2(18) NOT NULL | calendar id |
| 34 | CAL_RUN_ID | Character(18) | VARCHAR2(18) NOT NULL | Calendar Run Id |
| 35 | GP_PAYGROUP | Character(10) | VARCHAR2(10) NOT NULL | Global Payroll pay group |
| 36 | EMPLID_TO | Character(11) | VARCHAR2(11) NOT NULL | EmplID To |
| 37 | CALC_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Calculation Process Type. Identifies a run as either absence run or payroll run
A=Absence Calculation B=All Calculations P=Payroll Calculation |
| 38 | SEG_BGN_DT | Date(10) | DATE | Payee Process Segment's Begin Date |
| 39 | SEG_END_DT | Date(10) | DATE | Payee Process Segment's End Date |
| 40 | SEQ_NUM | Number(3,0) | SMALLINT NOT NULL | Sequence |
| 41 | ORIG_BEGIN_DT | Date(10) | DATE | original begin date |
| 42 | DELETE_IND | Character(1) | VARCHAR2(1) NOT NULL | Delete Indicator is used to indicate whether a row has been logically deleted. |
| 43 | GPBR_START_MONTH | Number(2,0) | SMALLINT NOT NULL | Start Month |
| 44 | GPBR_END_MONTH | Number(2,0) | SMALLINT NOT NULL | End Month |
| 45 | PAYMENT_DT | Date(10) | DATE | Payment Date |
| 46 | GPBR_CRED_BGN_DT | Date(10) | DATE | Credit Begin Date -- Vacations Brazil |
| 47 | GPBR_CRED_END_DT | Date(10) | DATE | Credit End Date Vacations Brazil |
| 48 | GPBR_CREDIT_DAYS | Number(3,0) | SMALLINT NOT NULL | Credit Days |
| 49 | GPBR_PAY_CREDIT | Number(1,0) | SMALLINT NOT NULL | Y N field Pay Credit for Programed Leaves |
| 50 | COMPANY | Character(3) | VARCHAR2(3) NOT NULL | Company |
| 51 | CAL_PRD_ID | Character(10) | VARCHAR2(10) NOT NULL |
Calendar Period ID
Prompt Table: GP_OFFCYCLE2_VW |
| 52 | OFF_CYCLE_ID | Character(18) | VARCHAR2(18) NOT NULL |
Off-Cycle Group or Request ID. ID field used to identify, group and manage a set of payments requested to be made as Off-cycle payments
Prompt Table: GP_OFFCYCL_SRCH |
| 53 | SRC_CAL_RUN_ID | Character(18) | VARCHAR2(18) NOT NULL | Source Calendar Run ID |