| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 WP_AGREEMENT_ID |
Character(5) |
VARCHAR2(5) NOT NULL |
Profit-Sharing: Agreement Identifier
|
| 2 |
DESCR50 |
Character(50) |
VARCHAR2(50) NOT NULL |
Description of length 50
|
| 3 |
DESCRSHORT |
Character(10) |
VARCHAR2(10) NOT NULL |
Short Description
|
| 4 |
WP_AGRT_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Agreement Type
S=Profit Sharing
W=Worker's Participation
Default Value: S
|
| 5 |
WP_AGRT_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Agreement Status
A=Approved
C=Construction in Progress
H=On Hold
Default Value: C
|
| 6 |
APPROVE_DATE |
Date(10) |
DATE |
This field is used to store the current approval date throughout batch processes.
|
| 7 |
DURATION |
Number(5,0) |
INTEGER NOT NULL |
Recurrence Duration
Default Value: 5
|
| 8 |
DURATION_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Type of Duration
D=Days
M=Months
Y=Years
Default Value: Y
|
| 9 |
START_DT |
Date(10) |
DATE NOT NULL |
Start Date
|
| 10 |
END_DT |
Date(10) |
DATE |
end date
|
| 11 |
WP_DURATION_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Agreement Duration
D=Determined
U=Undetermined
Default Value: D
|
| 12 |
WP_AGRT_SCOPE_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Agreement Scope
C=Company
G=Agreement Group
Default Value: C
|
| 13 |
COMPANY |
Character(3) |
VARCHAR2(3) NOT NULL |
Company
Prompt Table:
COMPANY_TBL
|
| 14 |
WP_AGRT_GRP_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Profit Sharing Agreement Group ID
Prompt Table:
WP_AGRT_GRP_TBL
|
| 15 |
WP_SENIORITY_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Seniority
Y/N Table Edit
Default Value: N
|
| 16 |
WP_SEN_DURATION |
Number(2,0) |
SMALLINT NOT NULL |
Seniority Eligibility Duration
|
| 17 |
WP_SEN_DUR_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Type of Duration
D=Days
M=Months
Y=Years
Default Value: M
|
| 18 |
WP_SURPLUS_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Profit Sharing Surplus
C=Carryover
I=Immediate Re-Share
N=None
Default Value: I
|
| 19 |
WP_INTEREST_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Profit-Sharing
I=Immediate
N=No Interest
R=Re-Invest
Default Value: I
|
| 20 |
CURRENCY_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Currency Code
Default Value: OPR_DEF_TBL_HR.EXCHNG_TO_CURRENCY
Prompt Table:
CURRENCY_CD_TBL
|
| 21 |
WP_PATH |
Character(200) |
VARCHAR2(200) NOT NULL |
Path for Agreement Document
|