WRK_OTH_EARNS(SQL Table) |
Index Back |
|---|---|
Work Record - Other EarningsThis work record contains earnings type information for other than regular or overtime earnings. It is used later in the process for PAY_OTH_EARNS record. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | COMPANY | Character(3) | VARCHAR2(3) NOT NULL |
Company
Prompt Table: COMPANY_TBL |
| 2 | PAYGROUP | Character(3) | VARCHAR2(3) NOT NULL | Pay Group |
| 3 | PAY_END_DT | Date(10) | DATE NOT NULL | Pay Period End Date |
| 4 | OFF_CYCLE | Character(1) | VARCHAR2(1) NOT NULL |
Off Cycle ?
Y/N Table Edit |
| 5 | PAGE_NUM | Number(4,0) | SMALLINT NOT NULL | Page # |
| 6 | LINE_NUM | Number(2,0) | SMALLINT NOT NULL | Line # |
| 7 | ADDL_NBR | Number(3,0) | SMALLINT NOT NULL | Additional Pay Line # |
| 8 | ERNCD | Character(3) | VARCHAR2(3) NOT NULL |
Earnings Code
Prompt Table: ERN_PROG_DESCR |
| 9 | SEPCHK | Number(1,0) | SMALLINT NOT NULL | Separate check number. |
| 10 | JOB_PAY | Character(1) | VARCHAR2(1) NOT NULL |
Job Pay
Y/N Table Edit |
| 11 | OTH_HRS | Signed Number(8,2) | DECIMAL(6,2) NOT NULL | Other Hours |
| 12 | OTH_PAY | Signed Number(12,2) | DECIMAL(10,2) NOT NULL | Other Pay |
| 13 | OTH_EARNS | Signed Number(12,2) | DECIMAL(10,2) NOT NULL | Other Earnings |
| 14 | ADD_GROSS | Character(1) | VARCHAR2(1) NOT NULL |
Add to Gross Pay
N=No Y=Yes Y/N Table Edit |
| 15 | TAX_METHOD | Character(1) | VARCHAR2(1) NOT NULL |
Tax method.
A=Annualized B=Bonus C=Cumulative G=Aggregate L=Lump Sum M=Commission P=Specified on Paysheet S=Supplemental X=Special Supplemental |
| 16 | ADDL_SEQ | Number(2,0) | SMALLINT NOT NULL | Additional Pay Sequence Number |
| 17 | TL_SOURCE | Character(1) | VARCHAR2(1) NOT NULL |
Time && Labor Source Flag
T=Time and Labor Record U=User Updated/Created Record |
| 18 | RATE_USED | Character(1) | VARCHAR2(1) NOT NULL |
Rate Used
A=Alternative Rate F=FLSA Rate H=Hourly Rate |
| 19 | BAS_CREDIT_SW | Character(1) | VARCHAR2(1) NOT NULL |
Benefits Admin Credit
Y/N Table Edit |
| 20 | COMP_RATECD | Character(6) | VARCHAR2(6) NOT NULL |
Comp Rate Code
Prompt Table: COMP_RT_REG_VW |
| 21 | COMPRATE | Number(19,6) | DECIMAL(18,6) NOT NULL | Compensation Rate |
| 22 | COMPRATE_USED | Number(19,6) | DECIMAL(18,6) NOT NULL | Comp Rate Used |
| 23 | HRS_DIST_SW | Character(1) | VARCHAR2(1) NOT NULL | Hours Distribution |
| 24 | XREF_NUM | Number(15,0) | DECIMAL(15) NOT NULL | T&L Xref Num |
| 25 | EX_DOC_ID | Character(10) | VARCHAR2(10) NOT NULL | Expense Doc ID |
| 26 | EX_DOC_TYPE | Character(1) | VARCHAR2(1) NOT NULL | Expense Doc Type |
| 27 | EX_LINE_NBR | Number(5,0) | INTEGER NOT NULL | Expense Line # |
| 28 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL | Currency Code |
| 29 | VC_PLAN_ID | Character(10) | VARCHAR2(10) NOT NULL | VC Plan ID |
| 30 | VC_PAYOUT_PRD_ID | Character(10) | VARCHAR2(10) NOT NULL | Payout Period ID |
| 31 | GB_GROUP_ID | Character(15) | VARCHAR2(15) NOT NULL | Group Build ID. |
| 32 | APPLID | Character(11) | VARCHAR2(11) NOT NULL | External Job Applicant ID |
| 33 | AWARD_DATE | Date(10) | DATE | Award Date |
| 34 | NOTIFY_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
eRecruit Status
N=Not Sent R=Reversed S=Sent to eRecruit Default Value: N |
| 35 | EIM_KEY | Character(20) | VARCHAR2(20) NOT NULL | SIM Sequence Number |