WP_ELIG_AET(SQL Table) |
Index Back |
|---|---|
State Record for EligiblityState record for Profit-Sharing Eligibility Process |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PROCESS_INSTANCE | Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 2 | OPRID | Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 3 | RUN_CNTL_ID | Character(30) | VARCHAR2(30) NOT NULL | Run Control ID |
| 4 | WP_AGREEMENT_ID | Character(5) | VARCHAR2(5) NOT NULL | Profit-Sharing: Agreement Identifier |
| 5 | PERIOD_ID | Character(12) | VARCHAR2(12) NOT NULL | Reference Period |
| 6 | WP_REINIT_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Re-Initialize ?
Y/N Table Edit Default Value: N |
| 7 | IF_FLAG | Character(1) | VARCHAR2(1) NOT NULL | If flag |
| 8 | WP_AGRT_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Agreement Type
S=Profit Sharing W=Worker's Participation |
| 9 | WP_AGRT_GRP_ID | Character(10) | VARCHAR2(10) NOT NULL |
Profit Sharing Agreement Group ID
Prompt Table: WP_AGRT_GRP_TBL |
| 10 | WP_AGRT_SCOPE_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Agreement Scope
C=Company G=Agreement Group |
| 11 | WP_SENIORITY_FLG | Character(1) | VARCHAR2(1) NOT NULL | Seniority |
| 12 | WP_SEN_DURATION | Number(2,0) | SMALLINT NOT NULL | Seniority Eligibility Duration |
| 13 | WP_SEN_DUR_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Type of Duration
D=Days M=Months Y=Years |
| 14 | COMPANY | Character(3) | VARCHAR2(3) NOT NULL | Company |
| 15 | ESTABID | Character(12) | VARCHAR2(12) NOT NULL | Establishment ID |
| 16 | EMPLID | Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 17 | EMPL_RCD | Number(3,0) | SMALLINT NOT NULL | Empl Rcd Nbr |
| 18 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL | Currency Code |
| 19 | CONTRACT_BEGIN_DT | Date(10) | DATE | Contract Begin Date |
| 20 | CONTRACT_END_DT | Date(10) | DATE | Contract End Date |
| 21 | WP_DURATION_DAYS | Number(6,0) | INTEGER NOT NULL | Duration Days |
| 22 | WP_SEN_DUR_DAYS | Number(5,0) | INTEGER NOT NULL | Seniority Duration in Days |
| 23 | WP_EE_PRO_FACTOR | Number(19,6) | DECIMAL(18,6) NOT NULL | Prorate factor used in profit-sharing calculation |
| 24 | WP_GROSS_PAY | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | Employee Salary |
| 25 | ORDER_SEQ | Number(3,0) | SMALLINT NOT NULL | Sequence Order for Processing |
| 26 | WP_AGRT_LEVEL_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Computation Level
A=Agreement Level E=Establishment Level W=Work Unit Level |
| 27 | WP_AGRT_LEVEL_ID | Character(15) | VARCHAR2(15) NOT NULL |
Agreement Level ID
Prompt Table: %RECNAME_EDIT |
| 28 | WP_FORMULA_ID | Character(10) | VARCHAR2(10) NOT NULL |
Profit Sharing Formula ID
Prompt Table: WP_FORMULA_TBL |
| 29 | WP_ROUND_RULE | Character(1) | VARCHAR2(1) NOT NULL |
Rounding Rule
D=Down S=Standard U=Up |
| 30 | DEC_PLACES | Number(3,0) | SMALLINT NOT NULL | Number of Decimal Places |
| 31 | WP_MAXDIS_FORM_ID | Character(10) | VARCHAR2(10) NOT NULL |
Global Fund Limit Formula
Prompt Table: WP_VARIABLE_TBL |
| 32 | WP_MAXSAL_FORM_ID | Character(10) | VARCHAR2(10) NOT NULL |
Individ. Salary Limit Formula
Prompt Table: WP_FORMULA_TBL |
| 33 | WP_MAXSAL_PRO_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Prorated
Y/N Table Edit Default Value: N |
| 34 | WP_MAXALC_FORM_ID | Character(10) | VARCHAR2(10) NOT NULL |
Individual Alloc Limit Formula
Prompt Table: WP_VARIABLE_TBL |
| 35 | WP_MAXALC_PRO_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Prorated
Y/N Table Edit Default Value: N |
| 36 | WP_SALARY_PRO_PCT | Number(6,2) | DECIMAL(5,2) NOT NULL | Prorate with Salary |
| 37 | WP_DURAT_PRO_PCT | Number(6,2) | DECIMAL(5,2) NOT NULL | Prorate with Working Duration |
| 38 | WP_UNIFORM_PRO_PCT | Number(6,2) | DECIMAL(5,2) NOT NULL | Uniform Distribution |
| 39 | WP_GROSS_SAL_ACCUM | Number(8,0) | INTEGER NOT NULL | Gross Salary Accumulator |
| 40 | WP_WORK_DAY_ACCUM | Number(8,0) | INTEGER NOT NULL | Working Days Accumulator |
| 41 | PIN_NUM | Number(8,0) | INTEGER NOT NULL | PIN Number |
| 42 | CURRENCY_CD2 | Character(3) | VARCHAR2(3) NOT NULL | Currency Code |
| 43 | CALC_RSLT_VAL | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | Calculation Numeric Result |
| 44 | FISCAL_BEGIN_DT | Date(10) | DATE | Fiscal Begin Date |
| 45 | FISCAL_END_DT | Date(10) | DATE | Fiscal End Date |
| 46 | CALC_VAL | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | Calculation Value |
| 47 | EXCHNG_TO_RT_TYPE | Character(5) | VARCHAR2(5) NOT NULL | Currency Rate Type |
| 48 | WP_EXT_PAYROLL_REC | Character(15) | VARCHAR2(15) NOT NULL | External Payroll Record |
| 49 | GROSS_PAY | Number(9,2) | DECIMAL(8,2) NOT NULL | GPFR: Gross pay |
| 50 | DAYS | Number(3,0) | SMALLINT NOT NULL | Days |
| 51 | BEGIN_DT | Date(10) | DATE | Begin Date |
| 52 | END_DT | Date(10) | DATE | end date |
| 53 | CONTRACT_NUM | Character(25) | VARCHAR2(25) NOT NULL | Contract Number |
| 54 | COUNTER | Number(10,0) | DECIMAL(10) NOT NULL | Counter |
| 55 | COMPANY_ALT | Character(3) | VARCHAR2(3) NOT NULL | Company |