COMPANYPrompt Table: COMPANY_TBL
EFFDTDefault Value: %date
SEQNUMDefault Value: 1
ABS_TYPE_OPTNPrompt Table: GP_ABS_TYPE
01=Close
02=Continue After Return
Default Value: 01
GPBR_LEA_PAR_VW(SQL View) |
Index Back |
|---|---|
Vacation Parameters ViewInterference View |
| SELECT A.COMPANY , A.EFFDT , A.SEQNUM , B.ABS_TYPE_OPTN , A.GPBR_ACTION_ABS , A.GPBR_VACN_DAYS_AP , A.GPBR_DAYS_CONT FROM PS_GPBR_LEAVE_PARM A , PS_GPBR_LEA_PARDET B WHERE A.COMPANY = B.COMPANY AND A.EFFDT = B.EFFDT AND A.SEQNUM = B.SEQNUM |
| # | 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 | SEQNUM |
Number(3,0) | SMALLINT NOT NULL |
Sequence Number
Default Value: 1 |
| 4 | ABS_TYPE_OPTN |
Character(3) | VARCHAR2(3) NOT NULL |
Absence Type
Prompt Table: GP_ABS_TYPE |
| 5 | GPBR_ACTION_ABS | Character(2) | VARCHAR2(2) NOT NULL |
Absence Type Action Brazil
01=Close 02=Continue After Return Default Value: 01 |
| 6 | GPBR_VACN_DAYS_AP | Number(3,0) | SMALLINT NOT NULL | Vacation Days Per Acquisitive Period |
| 7 | GPBR_DAYS_CONT | Number(1,0) | SMALLINT NOT NULL | Vacation Days Per Acquisitive Period |