HP_RDDEDDATMSVW(SQL View) |
Index Back |
|---|---|
Deductn Distributions with MsgView of Check Distribution Lines that have Warning or Error messages |
| SELECT A.HP_RUN_CNTL_ID , A.OPRID_LAST_UPDT , A.CREATION_DT , A.PAY_DT , A.HP_TRANSACTION_SRC , A.COMPANY , A.PAYGROUP , A.PAY_END_DT , A.OFF_CYCLE , A.PAGE_NUM , A.LINE_NUM , A.SEPCHK , A.HP_RDIST_TRANS_NO , A.HP_RDIST_SUB_TRANS , A.EMPL_RCD , A.PLAN_TYPE , A.BENEFIT_PLAN , A.DEDCD , A.DED_CLASS , A.HP_NEW_FISCAL_YEAR , A.HP_NEW_ACCT_PERIOD , A.HP_NEW_ACCT_CD , A.HP_NEW_ACCOUNT , A.NEW_DEPTID , A.NEW_POS_NBR , A.HP_NEW_JOBCODE , A.HP_NEW_POOL_ID , A.HP_NEW_DED_CUR , A.HP_ERROR_STATUS , A.HP_RETDIST_PAY_DT FROM PS_HP_RDIST_DEDDAT A WHERE EXISTS ( SELECT MSGSET FROM PS_HP_RDIST_DEDMSG B WHERE A.HP_RUN_CNTL_ID = B.HP_RUN_CNTL_ID AND A.OPRID_LAST_UPDT = B.OPRID_LAST_UPDT AND A.CREATION_DT = B.CREATION_DT AND A.PAY_DT = B.PAY_DT AND A.HP_TRANSACTION_SRC = B.HP_TRANSACTION_SRC AND A.COMPANY = B.COMPANY AND A.PAYGROUP = B.PAYGROUP AND A.PAY_END_DT = B.PAY_END_DT AND A.OFF_CYCLE = B.OFF_CYCLE AND A.PAGE_NUM = B.PAGE_NUM AND A.LINE_NUM = B.LINE_NUM AND A.SEPCHK = B.SEPCHK AND A.HP_RDIST_TRANS_NO = B.HP_RDIST_TRANS_NO AND A.HP_RDIST_SUB_TRANS = B.HP_RDIST_SUB_TRANS) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  HP_RUN_CNTL_ID |
Character(30) | VARCHAR2(30) NOT NULL | Run Control ID for Panles where two run controls are required |
| 2 | OPRID_LAST_UPDT |
Character(30) | VARCHAR2(30) NOT NULL | Last Operator to Update |
| 3 | CREATION_DT |
Date(10) | DATE | Creation Date |
| 4 | PAY_DT |
Date(10) | DATE | Date of Pay |
| 5 | HP_TRANSACTION_SRC |
Character(1) | VARCHAR2(1) NOT NULL |
Retro Distribution Transaction Source
B=Budget Changes R=Direct Access Changes |
| 6 | COMPANY |
Character(3) | VARCHAR2(3) NOT NULL |
Company
Prompt Table: COMPANY_TBL |
| 7 | PAYGROUP |
Character(3) | VARCHAR2(3) NOT NULL |
Pay Group
Prompt Table: PAYGROUP_TBL |
| 8 | PAY_END_DT |
Date(10) | DATE | Pay Period End Date |
| 9 | OFF_CYCLE |
Character(1) | VARCHAR2(1) NOT NULL |
Off Cycle ?
Y/N Table Edit |
| 10 | PAGE_NUM |
Number(5,0) | INTEGER NOT NULL | Page Nbr |
| 11 | LINE_NUM |
Number(3,0) | SMALLINT NOT NULL |
Line Nbr
Prompt Table: PAY_LINE |
| 12 | SEPCHK |
Number(2,0) | SMALLINT NOT NULL | Separate check number. |
| 13 | HP_RDIST_TRANS_NO |
Number(10,0) | DECIMAL(10) NOT NULL | Transaction Number |
| 14 | HP_RDIST_SUB_TRANS |
Number(5,0) | INTEGER NOT NULL | Secondary Transaction Number |
| 15 | EMPL_RCD | Number(3,0) | SMALLINT NOT NULL | Empl Record |
| 16 | PLAN_TYPE | Character(2) | VARCHAR2(2) NOT NULL | Identifies a category of benefit plan, such as Medical, Dental, and Life (Insurance). A set of plan type codes, as well as rules for creating new codes, is provided by PeopleSoft. Plan Type codes determine how the system processes and defines eligibility for the various benefit plans. |
| 17 | BENEFIT_PLAN | Character(6) | VARCHAR2(6) NOT NULL | Benefit Plan |
| 18 | DEDCD | Character(6) | VARCHAR2(6) NOT NULL | Deduction Code |
| 19 | DED_CLASS | Character(1) | VARCHAR2(1) NOT NULL |
Deduction Classification
A=After-Tax B=Before-Tax L=QC Taxable Benefit N=Nontaxable Benefit P=Nontaxable Btax Benefit T=Taxable Benefit |
| 20 | HP_NEW_FISCAL_YEAR | Number(4,0) | SMALLINT NOT NULL | New Fiscal Year |
| 21 | HP_NEW_ACCT_PERIOD | Number(3,0) | SMALLINT NOT NULL | New Accounting Period |
| 22 | HP_NEW_ACCT_CD | Character(25) | VARCHAR2(25) NOT NULL | New Account Code |
| 23 | HP_NEW_ACCOUNT | Character(10) | VARCHAR2(10) NOT NULL | New Account Retro Distribution |
| 24 | NEW_DEPTID | Character(10) | VARCHAR2(10) NOT NULL | New Department |
| 25 | NEW_POS_NBR | Character(8) | VARCHAR2(8) NOT NULL | New Position |
| 26 | HP_NEW_JOBCODE | Character(6) | VARCHAR2(6) NOT NULL | New Job Code |
| 27 | HP_NEW_POOL_ID | Character(3) | VARCHAR2(3) NOT NULL | New Position Pool ID |
| 28 | HP_NEW_DED_CUR | Signed Number(12,2) | DECIMAL(10,2) NOT NULL | New Current Deduction |
| 29 | HP_ERROR_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Retro Distribution Error Occurence
0=OK R=Rejected during Process T=Rejected during Creation |
| 30 | HP_RETDIST_PAY_DT | Date(10) | DATE | Retro Dist Pay End Date |