RDT_LABELREF_VW

(SQL View)
 Index Back

View on RDT_LABEL_REF record.

This view is used for the structure to cache the display templates.

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

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 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 MESSAGE_SET_NBR Number(5,0) INTEGER NOT NULL Message Set Number. This field refers to the Message Set Number in the Message Catalog.
6 MESSAGE_NBR Number(5,0) INTEGER NOT NULL Message Number. This field refers to the Message Number in the Message Catalog.