WP_AGRT_LEVEL(SQL Table) |
Index Back |
|---|---|
Agreemt Level Tbl |
| # | 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 | ORDER_SEQ |
Number(3,0) | SMALLINT NOT NULL |
Sequence Order for Processing
Default Value: 0 |
| 3 | WP_AGRT_LEVEL_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Computation Level
A=Agreement Level E=Establishment Level W=Work Unit Level Default Value: A |
| 4 | WP_AGRT_LEVEL_ID | Character(15) | VARCHAR2(15) NOT NULL |
Agreement Level ID
Prompt Table: %RECNAME_EDIT |
| 5 | WP_ROUND_RULE | Character(1) | VARCHAR2(1) NOT NULL |
Rounding Rule
D=Down S=Standard U=Up Default Value: S |
| 6 | WP_FORMULA_ID | Character(10) | VARCHAR2(10) NOT NULL |
Global Fund Formula
Prompt Table: WP_FORMULA_VW |
| 7 | DEC_PLACES | Number(3,0) | SMALLINT NOT NULL |
Number of Decimal Places
Default Value: 2 |
| 8 | WP_MAXDIS_FORM_ID | Character(10) | VARCHAR2(10) NOT NULL |
Global Fund Limit Formula
Prompt Table: WP_FORMULA_VW |
| 9 | WP_MAXSAL_FORM_ID | Character(10) | VARCHAR2(10) NOT NULL |
Individ. Salary Limit Formula
Prompt Table: WP_FORMULA_VW |
| 10 | WP_MAXSAL_PRO_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Prorated
Y/N Table Edit Default Value: N |
| 11 | WP_MAXALC_FORM_ID | Character(10) | VARCHAR2(10) NOT NULL |
Individual Alloc Limit Formula
Prompt Table: WP_FORMULA_VW |
| 12 | WP_MAXALC_PRO_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Prorated
Y/N Table Edit Default Value: N |
| 13 | WP_SALARY_PRO_PCT | Number(6,2) | DECIMAL(5,2) NOT NULL | Prorate with Salary |
| 14 | WP_DURAT_PRO_PCT | Number(6,2) | DECIMAL(5,2) NOT NULL | Prorate with Working Duration |
| 15 | WP_UNIFORM_PRO_PCT | Number(6,2) | DECIMAL(5,2) NOT NULL | Uniform Distribution |