POSN_EARNS_DIST(SQL Table) |
Index Back |
|---|---|
Position Earnings DistributionJOB_EARNS_DIST is a subordinate record to JOB. Use this record to specify how an employee's earnings should be posted for accounting purposes. For example, earnings can be posted to a job code, a department, a location, a General Ledger account, a position, or distributed among several categories. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  POSITION_NBR |
Character(8) | VARCHAR2(8) NOT NULL |
Position Number
Prompt Table: POSITION_DATA |
| 2 | EFFDT |
Date(10) | DATE NOT NULL |
Effective Date
Default Value: %date |
| 3 | DEPTID |
Character(10) | VARCHAR2(10) NOT NULL |
Department
Prompt Table: DEPT_TBL |
| 4 | JOBCODE |
Character(6) | VARCHAR2(6) NOT NULL |
Job Code
Prompt Table: JOBCODE_TBL |
| 5 | GL_PAY_TYPE |
Character(6) | VARCHAR2(6) NOT NULL | General Ledger Pay Type |
| 6 | ACCT_CD |
Character(25) | VARCHAR2(25) NOT NULL |
Combination Code
Prompt Table: ACCT_CD_TBL |
| 7 | SHIFT |
Character(1) | VARCHAR2(1) NOT NULL |
Regular Shift
1=1 2=2 3=3 A=Any C=Compressed N=Not Applicable R=Rotating |
| 8 | LOCATION |
Character(10) | VARCHAR2(10) NOT NULL |
Location Code
Prompt Table: LOCATION_TBL |
| 9 | ERNCD |
Character(3) | VARCHAR2(3) NOT NULL |
Earnings Code
Default Value: PAYGROUP_TBL.ERNCD_REG_EARNS Prompt Table: ERN_PROG_DESCR |
| 10 | DIST_PCT | Number(7,3) | DECIMAL(6,3) NOT NULL | Percent of Distribution |
| 11 | STD_HOURS | Number(7,2) | DECIMAL(6,2) NOT NULL | Standard Hours |