HP_RDIST_CTXMSG

(SQL View)
Index Back

Retro Distr Process Messages

Messages incurring as a result of Retro Distribution are placed in this table

SELECT HP_RUN_CNTL_ID , OPRID_LAST_UPDT , CREATION_DT , PAY_DT , HP_TRANSACTION_SRC , COMPANY , PAYGROUP , PAY_END_DT , OFF_CYCLE , PAGE_NUM , LINE_NUM , SEPCHK , HP_RDIST_TRANS_NO , HP_RDIST_SUB_TRANS , HP_RDIST_MSG_KEY , HP_PROGRAM_NAME , MSGSET , MESSAGE_NBR , MSGPARM1 FROM PS_HP_RDIST_MSGTBL WHERE HP_BUDGET_DATATYPE = 'C'

# 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 HP_RDIST_MSG_KEY Character(40) VARCHAR2(40) NOT NULL Message Table Concatenated Key
16 HP_PROGRAM_NAME Character(12) VARCHAR2(12) NOT NULL Application Program Name
17 MSGSET Number(5,0) INTEGER NOT NULL Message Set Number
18 MESSAGE_NBR Number(5,0) INTEGER NOT NULL Message Number. This field refers to the Message Number in the Message Catalog.
19 MSGPARM1 Character(30) VARCHAR2(30) NOT NULL Message Parm 1