MIL_TMPL_STKHLD (SQL Table)	Index Back
Military rank Template Defn This table is used to define templates which will be used to default as much data as possible into the rank change control component. This table specifically allows user to setup stakeholders to be used with the template.

MIL_TMPL_STKHLD

(SQL Table)

Military rank Template Defn

This table is used to define templates which will be used to default as much data as possible into the rank change control component. This table specifically allows user to setup stakeholders to be used with the template.

Parent record: MIL_TMPL_DEFN

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 MIL_TEMPLATE_ID Character(8) VARCHAR2(8) NOT NULL Military Rank Template unique identifier

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

3 MIL_PARTIC_INV Character(4) VARCHAR2(4) NOT NULL Participant Involvement
APRV=Approver
REVW=Reviewer

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	MIL_TEMPLATE_ID	Character(8)	VARCHAR2(8) NOT NULL	Military Rank Template unique identifier
2	ROLENAME	Character(30)	VARCHAR2(30) NOT NULL	The name of a Role in the Role Definition Table (see PSROLEDEFN).
3	MIL_PARTIC_INV	Character(4)	VARCHAR2(4) NOT NULL	Participant Involvement APRV=Approver REVW=Reviewer