HRS_XP_OFFTMP_V

(SQL View)
Index Back

XMLP report-template relation

Defines association between report definition and template definition for Offer Letters.

SELECT TMPLDEFN_ID , DESCR , IS_DEFAULT FROM PSXPRPTTMPL_VW WHERE REPORT_DEFN_ID = 'HRS_OFF_LET'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 HRS_REPORT_TMPL_ID Character(30) VARCHAR2(30) NOT NULL The Fusion publisher Report template ID used by RS.
2 DESCR Character(30) VARCHAR2(30) NOT NULL Description
3 IS_DEFAULT Character(1) VARCHAR2(1) NOT NULL Default Template
N=No
Y=Yes

Y/N Table Edit