CALC_NAMEDefault Value: PA_CLC_EMP_JOB.CALC_NAME
CALC_SEQ_NUMDefault Value: PA_CLC_EMP_JOB.CALC_SEQ_NUM
EMPLIDBENEFIT_PLANPrompt Table: PA_CLC_PLN_INPT
PA_CLC_MULTIJOB(SQL Table) |
Index Back |
|---|---|
Calc ResultsThis is an employee table. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | CALC_NAME |
Character(20) | VARCHAR2(20) NOT NULL |
Calculation Name
Default Value: PA_CLC_EMP_JOB.CALC_NAME |
| 2 | CALC_SEQ_NUM |
Number(9,0) | DECIMAL(9) NOT NULL |
Calc Seq Num
Default Value: PA_CLC_EMP_JOB.CALC_SEQ_NUM |
| 3 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 4 | BENEFIT_PLAN |
Character(6) | VARCHAR2(6) NOT NULL |
Benefit Plan
Prompt Table: PA_CLC_PLN_INPT |
| 5 | COMBINE_MULTIJOBS | Character(1) | VARCHAR2(1) NOT NULL | Combine Multiple Jobs |
| 6 | EMPL_RCD | Number(3,0) | SMALLINT NOT NULL | Empl Record |