WP_FORMULA_AET(SQL Table) |
Index Back |
|---|---|
Profit Sharing Formula CacheProfit Sharing Formula Calculation AET Record. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PROCESS_INSTANCE | Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 2 | WP_AGREEMENT_ID | Character(5) | VARCHAR2(5) NOT NULL | Profit-Sharing: Agreement Identifier |
| 3 | PERIOD_ID | Character(12) | VARCHAR2(12) NOT NULL | Reference Period |
| 4 | WP_FORMULA_ID | Character(10) | VARCHAR2(10) NOT NULL | Profit Sharing Formula ID |
| 5 | WP_FORMULA_ID2 | Character(10) | VARCHAR2(10) NOT NULL | Profit Sharing Formula ID |
| 6 | IF_FLAG | Character(1) | VARCHAR2(1) NOT NULL | If flag |
| 7 | EXCHNG_TO_RT_TYPE | Character(5) | VARCHAR2(5) NOT NULL | Currency Rate Type |
| 8 | WP_AGRT_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Agreement Type
S=Profit Sharing W=Worker's Participation |
| 9 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL |
Currency Code
Default Value: PSOPRDEFN.CURRENCY_CD Prompt Table: CURRENCY_CD_TBL |
| 10 | EMPLID | Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 11 | EMPL_RCD | Number(3,0) | SMALLINT NOT NULL | Empl Rcd Nbr |
| 12 | WP_AGRT_SCOPE_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Agreement Scope
C=Company G=Agreement Group Default Value: C |
| 13 | WP_VAR_SCOPE_REF | Character(15) | VARCHAR2(15) NOT NULL | Variable Scope Reference |
| 14 | COMPANY | Character(3) | VARCHAR2(3) NOT NULL |
Company
Prompt Table: COMPANY_TBL |
| 15 | WP_AGRT_GRP_ID | Character(10) | VARCHAR2(10) NOT NULL |
Profit Sharing Agreement Group ID
Prompt Table: WP_AGRT_GRP_TBL |
| 16 | SEQNO | Number(5,0) | INTEGER NOT NULL | Sequence Number |
| 17 | WP_OPERAND | Character(1) | VARCHAR2(1) NOT NULL |
Operand
(=( )=) *=* +=+ -=- /=/ F=Rec.Field R=Rate Code V=Constant W=Variable |
| 18 | WP_VALUE | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | Variable Value |
| 19 | COMP_RATECD | Character(6) | VARCHAR2(6) NOT NULL | Comp Rate Code |
| 20 | RECNAME | Character(15) | VARCHAR2(15) NOT NULL | Record (Table) Name (see PSRECDEFN). |
| 21 | FIELDNAME | Character(18) | VARCHAR2(18) NOT NULL | Field Name (see PSDBFIELD). |
| 22 | WP_VARIABLE_ID | Character(10) | VARCHAR2(10) NOT NULL | Variable ID |
| 23 | RATE_CODE_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Is Rate Code Overridable?
Default Value: N |
| 24 | WP_VALUE1 | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | Monetary Value |
| 25 | CURRENCY_CD1 | Character(3) | VARCHAR2(3) NOT NULL | Currency Code |
| 26 | WP_VALUE_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Value Type
M=Monetary N=Numeric Default Value: N |
| 27 | FROM_CLAUSE | Character(253) | VARCHAR2(253) NOT NULL | Scenario From Clause |
| 28 | WP_WHERE_CLAUSE | Character(254) | VARCHAR2(254) NOT NULL | Where Clause |
| 29 | WP_FORMULA_AMT | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | Formula Result Amount |
| 30 | WP_PRORATE_FLG | Character(1) | VARCHAR2(1) NOT NULL | Prorate with Period |
| 31 | FISCAL_BEGIN_DT | Date(10) | DATE | Fiscal Begin Date |
| 32 | FISCAL_END_DT | Date(10) | DATE | Fiscal End Date |
| 33 | COUNTER | Number(10,0) | DECIMAL(10) NOT NULL | Counter |
| 34 | ORDER_SEQ | Number(3,0) | SMALLINT NOT NULL | Sequence Order for Processing |
| 35 | WP_AGRT_LEVEL_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Computation Level
A=Agreement Level E=Establishment Level W=Work Unit Level |
| 36 | WP_AGRT_LEVEL_ID | Character(15) | VARCHAR2(15) NOT NULL | Agreement Level ID |
| 37 | WP_VAR_VAL_SCOPE | Character(1) | VARCHAR2(1) NOT NULL |
Variable Value Scope
A=Global C=Company E=Establishment G=Agreement Group W=Work Unit |
| 38 | ERROR_FLAG | Character(1) | VARCHAR2(1) NOT NULL | Error Flag |
| 39 | WP_FORMULA_SQL | Long Character | CLOB | Profit Sharing formula SQL |