HRS_XP_OFFTMP_V (SQL View)	Index Back
XMLP report-template relation Defines association between report definition and template definition for Offer Letters.

HRS_XP_OFFTMP_V

(SQL View)

XMLP report-template relation

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

SELECT A.TMPLDEFN_ID , B.DESCR , A.IS_DEFAULT FROM PSXPRPTTMPL A , PSXPTMPLDEFN B WHERE A.TMPLDEFN_ID = B.TMPLDEFN_ID AND REPORT_DEFN_ID = 'HRS_OFF_LET' AND EXISTS ( SELECT REPORT_DEFN_ID FROM PSXPRPTDEFN C WHERE A.REPORT_DEFN_ID = C.REPORT_DEFN_ID AND (C.PT_REPORT_STATUS IN ('A'))) AND EXISTS ( SELECT E.TMPLDEFN_ID FROM PSXPTMPLFILEDEF E WHERE A.TMPLDEFN_ID = E.TMPLDEFN_ID AND %EffdtCheck(PSXPTMPLFILEDEF F, E, %CurrentDateIn) AND E.TMPLFILE_STATUS = 'A')

# 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

#	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