HRS_XP_OFFTMP_V(SQL View) |
Index Back |
---|---|
XMLP report-template relationDefines 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 |