COUNTRYLVDN_PRGM_IDD=Days
H=Hours
B=Bank
I=Individual
E=Emergency
V=Voluntary
B=Recurring or One-Time
O=One-Time
R=Recurring
A=Annually
M=Monthly
Q=Quarterly
GP_ABS_LVDN_EVW(SQL View) |
Index Back |
|---|---|
Abs Mgmt Leave Donation ViewAbsence Management Leave Donation View |
| SELECT COUNTRY , LVDN_PRGM_ID , UNIT_TYPE , LVDN_PRGM_CATEGORY , LVDN_PRGM_TYPE , BEGIN_DT , END_DT , LVDN_CONTRIB_TYPE , LVDN_PRGM_MIN , LVDN_PRGM_MAX , LVDN_CONTRIB_FREQ , PYE_CEILING_LIMIT , PYE_CONTRIB_MIN , PYE_CONTRIB_MAX , DESCR FROM PS_GP_ABS_LVDN_PRG WHERE EFF_STATUS = 'A' AND BEGIN_DT <= %CurrentDateIn |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | COUNTRY |
Character(3) | VARCHAR2(3) NOT NULL | Country |
| 2 | LVDN_PRGM_ID |
Character(10) | VARCHAR2(10) NOT NULL | Leave Program |
| 3 | UNIT_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Unit Type in which the absence balances are displayed
D=Days H=Hours |
| 4 | LVDN_PRGM_CATEGORY | Character(1) | VARCHAR2(1) NOT NULL |
Leave Donation Program Category
B=Bank I=Individual |
| 5 | LVDN_PRGM_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Leave Program Type
E=Emergency V=Voluntary |
| 6 | BEGIN_DT | Date(10) | DATE | Begin Date |
| 7 | END_DT | Date(10) | DATE | end date |
| 8 | LVDN_CONTRIB_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Leave Donation Contribution Type
B=Recurring or One-Time O=One-Time R=Recurring |
| 9 | LVDN_PRGM_MIN | Signed Number(14,2) | DECIMAL(12,2) NOT NULL | Leave Donation Program Minimum Hours |
| 10 | LVDN_PRGM_MAX | Signed Number(14,2) | DECIMAL(12,2) NOT NULL | Leave Donation Program Maximum Hours |
| 11 | LVDN_CONTRIB_FREQ | Character(1) | VARCHAR2(1) NOT NULL |
Leave Donation Payee Contribution Frequency
A=Annually M=Monthly Q=Quarterly |
| 12 | PYE_CEILING_LIMIT | Signed Number(14,2) | DECIMAL(12,2) NOT NULL | Leave Donation Payee Contribution Limit for Program |
| 13 | PYE_CONTRIB_MIN | Signed Number(7,2) | DECIMAL(5,2) NOT NULL | Minimum |
| 14 | PYE_CONTRIB_MAX | Signed Number(7,2) | DECIMAL(5,2) NOT NULL | Maximum |
| 15 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |