PAY_CHECK_EARNS(SQL Table) |
Index Back |
---|---|
Pay Check EarningsThis table contains earnings information created during the payroll calculation process. A separate record will be created for each earnings code. |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | Character(3) | VARCHAR2(3) NOT NULL |
Company
Prompt Table: COMPANY_TBL |
|
2 | Character(3) | VARCHAR2(3) NOT NULL |
Pay Group
Prompt Table: PAYGROUP_TBL |
|
3 | Date(10) | DATE NOT NULL |
Pay Period End Date
Prompt Table: PAY_CALENDAR |
|
4 | Character(1) | VARCHAR2(1) NOT NULL |
Off Cycle ?
Y/N Table Edit |
|
5 | Number(4,0) | SMALLINT NOT NULL | Page # | |
6 | Number(2,0) | SMALLINT NOT NULL | Line # | |
7 | Number(1,0) | SMALLINT NOT NULL | Separate check number. | |
8 | Number(3,0) | SMALLINT NOT NULL | Additional Pay Line # | |
9 | Character(3) | VARCHAR2(3) NOT NULL | Earnings Code | |
10 | Character(25) | VARCHAR2(25) NOT NULL | Combination Code | |
11 | Character(5) | VARCHAR2(5) NOT NULL | Business Unit | |
12 | Character(10) | VARCHAR2(10) NOT NULL | Department | |
13 | Character(6) | VARCHAR2(6) NOT NULL | Job Code | |
14 | Character(8) | VARCHAR2(8) NOT NULL | Position Number | |
15 | Number(3,0) | SMALLINT NOT NULL | Empl Rcd Nbr | |
16 | EARNINGS | Signed Number(15,2) | DECIMAL(13,2) NOT NULL | Earnings |
17 | REVERSED | Character(1) | VARCHAR2(1) NOT NULL |
Reversed
Y/N Table Edit Default Value: N |
18 | ADD_GROSS | Character(1) | VARCHAR2(1) NOT NULL |
Add to Gross Pay
N=No Y=Yes |
19 | BUDGET_DEPTID | Character(10) | VARCHAR2(10) NOT NULL | Budget with Department |
20 | DIST_PRORATE_OPTN | Character(1) | VARCHAR2(1) NOT NULL |
Distribution Prorate Option
C=Calendar Days I=For Internal System Use Only N=Not Applicable W=Work Days |
21 | EX_DOC_ID | Character(10) | VARCHAR2(10) NOT NULL | Expense Doc ID |
22 | EX_DOC_TYPE | Character(1) | VARCHAR2(1) NOT NULL | Expense Doc Type |
23 | EX_LINE_NBR | Number(5,0) | INTEGER NOT NULL | Expense Line # |
24 | DIST_CHECK_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
PayCheck Distribution Status
F=Rev Check - Release Fund Req N=Regular Check R=Rev Check - Release Fund Comp X=Same Pay Period Reversal / Adj Default Value: N |
25 | EARNS_BEGIN_DT | Date(10) | DATE | Earnings Begin Date |
26 | EARNS_END_DT | Date(10) | DATE | Earnings End Date |