HP_RDIST_MSGTBL

#	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(4,0)	SMALLINT NOT NULL	Page #
11	LINE_NUM	Number(2,0)	SMALLINT NOT NULL	Line # Prompt Table: PAY_LINE
12	SEPCHK	Number(1,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	HP_BUDGET_DATATYPE	Character(2)	VARCHAR2(2) NOT NULL	Budget Data Type for specifying if Earnings, Deductions, or Taxes A=All D=Deductions DT=Deductions and Taxes E=Earnings ED=Earnings and Deductions ET=Earnings and Taxes T=Tax
18	MSGSET	Number(5,0)	INTEGER NOT NULL	Message Set Number
19	MESSAGE_NBR	Number(5,0)	INTEGER NOT NULL	Message Number. This field refers to the Message Number in the Message Catalog.
20	MSGPARM1	Character(30)	VARCHAR2(30) NOT NULL	Message Parm 1