COUNTRYELIG_GRPABS_TYPE_OPTNPIN_NUMEFFDTDefault Value: %date
A=Administrator
B=Employee and Manager
E=Employee
M=Manager
GP_ABSEA_TYP_VW(SQL View) |
Index Back |
|---|---|
Extended Abs Take Types in SSPrompt view used to list extended absence take types available for Self Service |
| SELECT DISTINCT SS.COUNTRY , ELIG.ELIG_GRP , T.ABS_TYPE_OPTN , SS.PIN_TAKE_NUM , ELIG.EFFDT , T.DESCR ,SS.RQST_ALLOWED_BY FROM PS_GP_ABS_TAKE TK , PS_GP_PIN PIN , PS_GP_ABS_SS SS , PS_GP_ELEM_GRP_MBR ELEMM , PS_GP_ELEM_GRP ELEM , PS_GP_ELIG_GRP_MBR ELIGM , PS_GP_ELIG_GRP ELIG , PS_GP_ABS_TYPE T WHERE TK.PIN_NUM < 50000000 AND TK.PIN_NUM = SS.PIN_TAKE_NUM AND TK.PIN_NUM = PIN.PIN_NUM AND %EffdtCheck(GP_ABS_SS, SS, %CurrentDateIn) AND SS.EFF_STATUS = 'A' AND SS.ALLOW_EA_ENTRY = 'Y' AND TK.PIN_NUM = ELEMM.PIN_ELEM_NUM AND ELEMM.PIN_NUM = ELEM.PIN_NUM AND ELEMM.EFFDT = ELEM.EFFDT AND %EffdtCheck(GP_ELEM_GRP, ELEM, %CurrentDateIn) AND ELEM.EFF_STATUS = 'A' AND ELEM.PIN_NUM = ELIGM.PIN_ELEM_GRP_NUM AND ELIGM.ELIG_GRP = ELIG.ELIG_GRP AND ELIGM.EFFDT = ELIG.EFFDT AND %EffdtCheck(GP_ABS_TAKE, TK, %CurrentDateIn) AND T.EFF_STATUS = 'A' AND T.REQUEST_IND = 'Y' AND T.ABS_TYPE_OPTN = TK.ABS_TYPE_OPTN AND T.COUNTRY = PIN.COUNTRY AND %EffdtCheck(GP_ABS_TYPE, T, %CurrentDateIn) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | COUNTRY |
Character(3) | VARCHAR2(3) NOT NULL | Country |
| 2 | ELIG_GRP |
Character(10) | VARCHAR2(10) NOT NULL | eligibility group |
| 3 | ABS_TYPE_OPTN |
Character(3) | VARCHAR2(3) NOT NULL | Absence Type |
| 4 | PIN_NUM |
Number(8,0) | INTEGER NOT NULL | PIN Number |
| 5 | EFFDT |
Date(10) | DATE |
Effective Date
Default Value: %date |
| 6 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 7 | RQST_ALLOWED_BY | Character(1) | VARCHAR2(1) NOT NULL |
This field dictates who can request a specific absence take in self-service.
A=Administrator B=Employee and Manager E=Employee M=Manager |