USED_BYA=All Countries
C=Specific Country
COUNTRYABS_TYPE_OPTNEFFDTDefault Value: %date
ABSENCE_REASONLANGUAGE_CDGP_ABSEA_RSN_LV(SQL View) |
Index Back |
|---|---|
Langview for ABSEA RSN VWPrompt 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.LANGUAGE_CD , A.DESCR FROM PS_GP_ABS_RSN_LANG 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
Default Value: %date |
| 5 | ABSENCE_REASON |
Character(3) | VARCHAR2(3) NOT NULL | absence reason |
| 6 | LANGUAGE_CD |
Character(3) | VARCHAR2(3) NOT NULL | Language Code |
| 7 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |