IN_TM_HDRSEC_VW (SQL View)	Index Back
Tmplt Maint search rec base vw Base view for IN_TM_HDRSC_DVW, the Template Maintenance search record

IN_TM_HDRSEC_VW

(SQL View)

Tmplt Maint search rec base vw

Base view for IN_TM_HDRSC_DVW, the Template Maintenance search record

SELECT DISTINCT HDR.IN_TM_CODE , HDR.TEMPLATE_ID , SEC.OPRID , SEC.ROLENAME , HDR.DESCR FROM PS_IN_TM_OPR_HDR HDR , PS_IN_TM_OPR_SEC SEC WHERE SEC.IN_TM_CODE = HDR.IN_TM_CODE AND SEC.TEMPLATE_ID = HDR.TEMPLATE_ID

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 IN_TM_CODE Character(15) VARCHAR2(15) NOT NULL Template Code

2 TEMPLATE_ID Character(30) VARCHAR2(30) NOT NULL Project Template

3 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).

4 ROLENAME Character(30) VARCHAR2(30) NOT NULL The name of a Role in the Role Definition Table (see PSROLEDEFN).

5 DESCR Character(30) VARCHAR2(30) NOT NULL Description

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	IN_TM_CODE	Character(15)	VARCHAR2(15) NOT NULL	Template Code
2	TEMPLATE_ID	Character(30)	VARCHAR2(30) NOT NULL	Project Template
3	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
4	ROLENAME	Character(30)	VARCHAR2(30) NOT NULL	The name of a Role in the Role Definition Table (see PSROLEDEFN).
5	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description