JOBEARNSDIST_CV(SQL View) |
Index Back |
|---|---|
JOB_EARNS_DIST ClairviaClone of JOB_EARNS_DIST record for Clairvia Fullsync message |
| SELECT EARNS.EMPLID , EARNS.EMPL_RCD , EARNS.EFFDT , EARNS.EFFSEQ , EARNS.POSITION_NBR , EARNS.BUSINESS_UNIT , EARNS.DEPTID , EARNS.JOBCODE , EARNS.GL_PAY_TYPE , EARNS.ACCT_CD , EARNS.SHIFT , EARNS.LOCATION , EARNS.ERNCD , EARNS.COMPRATE , EARNS.DIST_PCT , EARNS.STD_HOURS FROM PS_JOB_EARNS_DIST EARNS , PS_PER_ORG_ASG_INT ASG WHERE ASG.EMPLID = EARNS.EMPLID AND ASG.EMPL_RCD = EARNS.EMPL_RCD AND ASG.INT_APP_TYPE = 'SCH' AND ASG.INTEGR_PROD_CD = 'CV' AND ASG.ENROLLED_FLAG = 'Y' |
| # | 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 Record |
| 3 | EFFDT |
Date(10) | DATE NOT NULL |
Effective Date
Default Value: JOB.EFFDT |
| 4 | EFFSEQ |
Number(3,0) | SMALLINT NOT NULL | Effective Sequence |
| 5 | POSITION_NBR |
Character(8) | VARCHAR2(8) NOT NULL |
Position Number
Prompt Table: POSITION_DATA |
| 6 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Prompt Table: BUS_UNIT_TBL_HR |
| 7 | DEPTID |
Character(10) | VARCHAR2(10) NOT NULL |
Department
Prompt Table: DEPT_TBL |
| 8 | JOBCODE |
Character(6) | VARCHAR2(6) NOT NULL |
Job Code
Prompt Table: JOBCODE_TBL |
| 9 | GL_PAY_TYPE |
Character(6) | VARCHAR2(6) NOT NULL | General Ledger Pay Type |
| 10 | ACCT_CD |
Character(25) | VARCHAR2(25) NOT NULL |
Combination Code
Prompt Table: %EDITTABLE |
| 11 | SHIFT |
Character(1) | VARCHAR2(1) NOT NULL |
Regular Shift
1=Day 2=Evening 3=Night A=Any C=Compressed N=Not Applicable R=Rotating Default Value: N |
| 12 | LOCATION |
Character(10) | VARCHAR2(10) NOT NULL |
Location Code
Prompt Table: LOCATION_TBL |
| 13 | ERNCD |
Character(3) | VARCHAR2(3) NOT NULL |
Earnings Code
Default Value: PAYGROUP_TBL.ERNCD_REG_EARNS Prompt Table: ERN_PROG_DESCR |
| 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 |