RDT_GOTOLBL_VW

(SQL View)
 Index Back

Label References

This view returns the label references for the fields which are part of the display template.

SELECT LABEL_REF_ID ,LBL_CATEGORY ,LABEL_ID ,LBLTYPE ,ONVALUE ,MESSAGE_SET_NBR ,MESSAGE_NBR FROM PS_RDT_LABEL_REF

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 GOTO_LABEL_REF_ID Number(31,0) DECIMAL(31) NOT NULL Label reference id for the fields which are part of the display template.
2 LBL_CATEGORY Character(3) VARCHAR2(3) NOT NULL Label category to use when the label is changed for the fields which are part of the display template.
LBL=Field Label
MSG=Message Catalog
3 LABEL_ID Character(18) VARCHAR2(18) NOT NULL LABEL_ID identifies uniquness of DB Field Labels. This field is used in PSDBFLDLABL and PSDBFLDLABLLANG.
4 LBLTYPE Number(1,0) SMALLINT NOT NULL Label Type
5 ONVALUE Character(4) VARCHAR2(4) NOT NULL On Value
6 MESSAGE_SET_NBR Number(5,0) INTEGER NOT NULL Message Set Number. This field refers to the Message Set Number in the Message Catalog.
7 MESSAGE_NBR Number(5,0) INTEGER NOT NULL Message Number. This field refers to the Message Number in the Message Catalog.