TSE_HYPL_VW

(SQL View)
 Index Back

SELECT a.business_unit ,b.HYP_TRAN_ID ,b.HYP_LINE_NBR ,b.tse_jobid ,b.tse_proc_instance ,b.tse_set_nbr ,b.tse_edit_type ,b.tse_fieldname ,b.message_set_nbr ,b.message_nbr ,b.message_parm ,b.message_parm2 ,b.message_parm3 FROM PS_HYP_KK_BD_HDR a ,ps_TSE_HYPL_FLD b WHERE a.business_unit=b.business_unit AND a.HYP_TRAN_ID=b.HYP_TRAN_ID

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
2 HYP_TRAN_ID Character(44) VARCHAR2(44) NOT NULL Commitment Control Foreign Key for Transaction Identification.
3 HYP_LINE_NBR Number(9,0) DECIMAL(9) NOT NULL Uniquely identifies a journal line with a sequence number. Within a single journal entry, the line sequence begins with 1 and automatically increments by 1 for each succeeding journal line. There can be any number of lines associated with a journal header.
4 TSE_JOBID Character(10) VARCHAR2(10) NOT NULL TSE Job Identifier
5 TSE_PROC_INSTANCE Number(10,0) DECIMAL(10) NOT NULL TSE Run ID
6 TSE_SET_NBR Number(6,0) INTEGER NOT NULL TSE Set Number
7 TSE_EDIT_TYPE Character(1) VARCHAR2(1) NOT NULL TSE Edit Type
A=Application Edit
D=Date Range Edit
P=Prompt Table Edit
R=Required Field Edit
X=Translate Table Edit
Y=Yes/No Edit
8 TSE_FIELDNAME Character(18) VARCHAR2(18) NOT NULL TSE Field Name
9 MESSAGE_SET_NBR Number(5,0) INTEGER NOT NULL Message Set Number. This field refers to the Message Set Number in the Message Catalog.
10 MESSAGE_NBR Number(5,0) INTEGER NOT NULL Message Number. This field refers to the Message Number in the Message Catalog.
11 MESSAGE_PARM Character(254) VARCHAR2(254) NOT NULL Message Parameter Text
12 MESSAGE_PARM2 Character(30) VARCHAR2(30) NOT NULL Message Parameter 2
13 MESSAGE_PARM3 Character(30) VARCHAR2(30) NOT NULL Message Parameter 3