USED_BYA=All Countries
C=Specific Country
COUNTRYABS_TYPE_OPTNEFFDTABSENCE_REASON10=Vacations
GP_ABS_REASN_VW(SQL View) |
Index Back |
|---|---|
PIN num view of ABS REASONPrompt view against Absence Reason keyed by PIN NUM without requiring USED BY or COUNTRY present on page. Used on Absence Self Service where separate COUNTRY field interfers with lookup to Absence Reasons used by ALL countries |
| SELECT A.USED_BY , A.COUNTRY , A.ABS_TYPE_OPTN , A.EFFDT , A.ABSENCE_REASON , A.DESCR FROM PS_GP_ABS_REASON A |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | USED_BY |
Character(1) | VARCHAR2(1) NOT NULL |
USED_BY
A=All Countries C=Specific Country |
| 2 | COUNTRY |
Character(3) | VARCHAR2(3) NOT NULL | Country |
| 3 | ABS_TYPE_OPTN |
Character(3) | VARCHAR2(3) NOT NULL | Absence Type |
| 4 | EFFDT |
Date(10) | DATE | Effective Date |
| 5 | ABSENCE_REASON |
Character(3) | VARCHAR2(3) NOT NULL |
absence reason
10=Vacations |
| 6 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |