UPG_JOBEARNSTMP(SQL Table) |
Index Back |
|---|---|
Upgrade tmp tbl JOB_EARNS_TMPTemp table used for upgrade of JOB_EARNS_DIST table for the Alternative Overtime payroll feature |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  EMPLID |
Character(11) | VARCHAR2(11) NOT NULL |
Employee ID
Default Value: NEW Prompt Table: PERSON |
| 2 | EMPL_RCD |
Number(3,0) | SMALLINT NOT NULL | Empl Rcd Nbr |
| 3 | EFFDT |
Date(10) | DATE NOT NULL |
Effective Date
Default Value: JOB.EFFDT |
| 4 | EFFSEQ |
Number(3,0) | SMALLINT NOT NULL | Effective Sequence |
| 5 | DEPTID |
Character(10) | VARCHAR2(10) NOT NULL |
Department
Prompt Table: DEPT_TBL |
| 6 | JOBCODE |
Character(6) | VARCHAR2(6) NOT NULL |
Job Code
Prompt Table: JOBCODE_TBL |
| 7 | POSITION_NBR |
Character(8) | VARCHAR2(8) NOT NULL |
Position Number
Prompt Table: POSITION_DATA |
| 8 | GL_PAY_TYPE |
Character(6) | VARCHAR2(6) NOT NULL | General Ledger Pay Type |
| 9 | ACCT_CD |
Character(25) | VARCHAR2(25) NOT NULL |
Combination Code
Prompt Table: %EDITTABLE |
| 10 | SHIFT |
Character(1) | VARCHAR2(1) NOT NULL |
Regular Shift
1=1 2=2 3=3 A=Any C=Compressed N=Not Applicable R=Rotating Default Value: N |
| 11 | LOCATION |
Character(10) | VARCHAR2(10) NOT NULL |
Location Code
Prompt Table: LOCATION_TBL |
| 12 | ERNCD |
Character(3) | VARCHAR2(3) NOT NULL |
Earnings Code
Default Value: PAYGROUP_TBL.ERNCD_REG_EARNS Prompt Table: ERN_PROG_DESCR |
| 13 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Prompt Table: BUS_UNIT_TBL_HR |
| 14 | COMPRATE | Number(19,6) | DECIMAL(18,6) NOT NULL | Compensation Rate |
| 15 | DIST_PCT | Number(7,3) | DECIMAL(6,3) NOT NULL | Percent of Distribution |
| 16 | STD_HOURS | Number(7,2) | DECIMAL(6,2) NOT NULL | Standard Hours |