| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 COUNTRY |
Character(3) |
VARCHAR2(3) NOT NULL |
Country
Prompt Table:
GP_COUNTRY_VW
Set Control Field: COUNTRY
|
| 2 |
LVDN_PRGM_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Leave Program
|
| 3 |
EFF_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Effective Status
A=Active
I=Inactive
Default Value: A
|
| 4 |
DESCR |
Character(30) |
VARCHAR2(30) NOT NULL |
Description
|
| 5 |
DESCRSHORT |
Character(10) |
VARCHAR2(10) NOT NULL |
Short Description
|
| 6 |
UNIT_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Unit Type in which the absence balances are displayed
D=Days
H=Hours
Default Value: H
|
| 7 |
LVDN_PRGM_CATEGORY |
Character(1) |
VARCHAR2(1) NOT NULL |
Leave Donation Program Category
B=Bank
I=Individual
Default Value: I
|
| 8 |
LVDN_PRGM_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Leave Program Type
E=Emergency
V=Voluntary
Default Value: V
|
| 9 |
BEGIN_DT |
Date(10) |
DATE NOT NULL |
Begin Date
Default Value: %date
|
| 10 |
END_DT |
Date(10) |
DATE |
end date
|
| 11 |
LVDN_TARGT_ACCRUAL |
Signed Number(14,2) |
DECIMAL(12,2) NOT NULL |
Target Donation
|
| 12 |
LVDN_CONTRIB_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Leave Donation Contribution Type
B=Recurring or One-Time
O=One-Time
R=Recurring
Default Value: O
|
| 13 |
LVDN_PRGM_MIN |
Signed Number(14,2) |
DECIMAL(12,2) NOT NULL |
Leave Donation Program Minimum Hours
|
| 14 |
LVDN_PRGM_MAX |
Signed Number(14,2) |
DECIMAL(12,2) NOT NULL |
Leave Donation Program Maximum Hours
|
| 15 |
LVDN_CONTRIB_FREQ |
Character(1) |
VARCHAR2(1) NOT NULL |
Leave Donation Payee Contribution Frequency
A=Annually
M=Monthly
Q=Quarterly
|
| 16 |
PYE_CONTRIB_MIN |
Signed Number(7,2) |
DECIMAL(5,2) NOT NULL |
Minimum
|
| 17 |
PYE_CONTRIB_MAX |
Signed Number(7,2) |
DECIMAL(5,2) NOT NULL |
Maximum
|
| 18 |
PYE_CEILING_LIMIT |
Signed Number(14,2) |
DECIMAL(12,2) NOT NULL |
Leave Donation Payee Contribution Limit for Program
|
| 19 |
ALLOW_RETURN |
Character(1) |
VARCHAR2(1) NOT NULL |
Leave Donation Allow Recipient to Return Leave
Y/N Table Edit
|
| 20 |
LVDN_USAGE_ALLOC |
Character(1) |
VARCHAR2(1) NOT NULL |
Usage Allocation Method
F=First In First Out
W=Weighted Average
|
| 21 |
PRGM_TERMINATION |
Character(1) |
VARCHAR2(1) NOT NULL |
Program Termination
N=No
Y=Yes
Y/N Table Edit
|
| 22 |
QUALIFIED_MEMBER |
Character(1) |
VARCHAR2(1) NOT NULL |
Qualified Member
N=No
Y=Yes
Y/N Table Edit
|
| 23 |
EOAWPRCS_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
Approval Process ID
Prompt Table:
GP_ABS_AWPR_VW1
|
| 24 |
EOAWDEFN_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
Approval Framework Definition ID
Prompt Table:
GP_ABS_AWPR_VW2
|