CALC_NAMECALC_SEQ_NUMEMPLIDEFFDTEFFSEQEMPL_RCDDefault Value: 0
E=Exception Hourly
H=Hourly
N=Not Applicable
S=Salaried
Prompt Table: ACTION_TBL
PA_CLC_EMP_JOB(SQL Table) |
Index Back |
|---|---|
Calc Results Employee Job HistThis is an employee table containing the Employee Job History at the time the calculation was run. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | CALC_NAME |
Character(20) | VARCHAR2(20) NOT NULL | Calculation Name |
| 2 | CALC_SEQ_NUM |
Number(9,0) | DECIMAL(9) NOT NULL | Calc Seq Num |
| 3 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 4 | EFFDT |
Date(10) | DATE | Effective Date |
| 5 | EFFSEQ |
Number(3,0) | SMALLINT NOT NULL | Effective Sequence |
| 6 | EMPL_RCD |
Number(3,0) | SMALLINT NOT NULL |
Empl Record
Default Value: 0 |
| 7 | EMPL_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Employee Type
E=Exception Hourly H=Hourly N=Not Applicable S=Salaried |
| 8 | ACTION | Character(3) | VARCHAR2(3) NOT NULL |
Action
Prompt Table: ACTION_TBL |
| 9 | ACTION_DT | Date(10) | DATE | Action Date |
| 10 | ACTION_REASON | Character(3) | VARCHAR2(3) NOT NULL | Reason Code |