GPBR_NRP_VAP_VW(SQL View) |
Index Back |
|---|---|
Vacation Parameters by UnionVacation Parameters by Union |
| SELECT COMPANY ,EFFDT ,GPBR_VACN_DAYS_AP ,GPBR_NEG_BALANCE ,GPBR_NEG_BAL_LIMIT ,GPBR_LEAVES_PER_AP ,GPBR_MIN_AGE_PART ,GPBR_MAX_AGE_PART ,GPBR_MIN_DAY_ALLOW ,GPBR_MAX_VAC_PER ,GPBR_MAX_PCT_LEAVE ,GPBR_CRE_TREATMENT ,GPBR_13TH_CALC_SEP ,GPBR_NEED_CONFIRM ,PIN_TAKE_NUM + 50000000 ,GPBR_PIN_TAKEC_NUM + 50000000 ,PIN_ENT_NUM + 50000000 ,GPBR_CALID_VAC_ABS ,GPBR_CALID_VAC_PAY ,GPBR_PIN_TAKE_NUM + 50000000 ,GPBR_VAC_CRED_PER ,GP_TX_REASON FROM PS_GPBR_VACN_PARM |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  COMPANY |
Character(3) | VARCHAR2(3) NOT NULL |
Company
Prompt Table: COMPANY_TBL |
| 2 | EFFDT |
Date(10) | DATE NOT NULL |
Effective Date
Default Value: %date |
| 3 | GPBR_VACN_DAYS_AP | Number(3,0) | SMALLINT NOT NULL | Vacation Days Per Acquisitive Period |
| 4 | GPBR_NEG_BALANCE | Number(1,0) | SMALLINT NOT NULL |
Allow Negative Balance Vacation Parameters Brazil
Default Value: N |
| 5 | GPBR_NEG_BAL_LIMIT | Number(2,0) | SMALLINT NOT NULL | Negative Balance Limit |
| 6 | GPBR_LEAVES_PER_AP | Number(2,0) | SMALLINT NOT NULL | Vacation Days per Acquisitive Period |
| 7 | GPBR_MIN_AGE_PART | Number(2,0) | SMALLINT NOT NULL |
Minimum Age for Partiality
Default Value: 18 |
| 8 | GPBR_MAX_AGE_PART | Number(2,0) | SMALLINT NOT NULL |
Maximum Age for Partiality
Default Value: 50 |
| 9 | GPBR_MIN_DAY_ALLOW | Number(2,0) | SMALLINT NOT NULL | Minimum Days Allowed by Leave |
| 10 | GPBR_MAX_VAC_PER | Number(2,0) | SMALLINT NOT NULL | Maximum Vacation Days per Period |
| 11 | GPBR_MAX_PCT_LEAVE | Number(6,2) | DECIMAL(5,2) NOT NULL | Maximum Percent per Leave |
| 12 | GPBR_CRE_TREATMENT | Character(2) | VARCHAR2(2) NOT NULL |
Credit Treatment
01=Starting Month 02=End of Vacations 03=Proportional Vacation Days Default Value: 01 |
| 13 | GPBR_13TH_CALC_SEP | Number(1,0) | SMALLINT NOT NULL |
13th Calculate Separately
Default Value: Y |
| 14 | GPBR_NEED_CONFIRM | Number(1,0) | SMALLINT NOT NULL |
Needs Confirmation for Program
Default Value: N |
| 15 | PIN_TAKE_NUM | Number(8,0) | INTEGER NOT NULL |
Absence Take
Prompt Table: GP_PIN_ABSTK_VW |
| 16 | GPBR_PIN_TAKEC_NUM | Number(8,0) | INTEGER NOT NULL |
Absence Take Credit Brazil
Prompt Table: GP_PIN_ABSTK_VW |
| 17 | PIN_ENT_NUM | Number(8,0) | INTEGER NOT NULL |
Element number field
Prompt Table: GP_PIN_AE5_VW |
| 18 | GPBR_CALID_VAC_ABS | Character(14) | VARCHAR2(14) NOT NULL | calendar id |
| 19 | GPBR_CALID_VAC_PAY | Character(14) | VARCHAR2(14) NOT NULL | calendar id |
| 20 | GPBR_PIN_TAKE_NUM | Number(8,0) | INTEGER NOT NULL | Absence Take Proportional Brazil |
| 21 | GPBR_VAC_CRED_PER | Character(1) | VARCHAR2(1) NOT NULL |
Union Parameter to indicate if always allow vacation credit.
Y/N Table Edit Default Value: N |
| 22 | GP_TX_REASON | Character(18) | VARCHAR2(18) NOT NULL |
Off Cycle (Transaction) Reason
Identifies a particular configuration to be applied to the presentation of off cycle request information
Prompt Table: GPBR_OC_SETUP_A |