RSP_ACCT_TMPL_V (SQL View)	Index Back
Prompt record for templates This record is used for prompting on the templates valid for account planning.

RSP_ACCT_TMPL_V

(SQL View)

Prompt record for templates

This record is used for prompting on the templates valid for account planning.

SELECT A.SETID , B.ROLE_TYPE_ID , B.RSP_PLAN_TYPE , RSP_UID20 , RSP_NAME , PERIOD_TYPE , START_DATE , END_DATE FROM %Table(RSP_TMPL_A_VW) A , %Table(RSP_PTYP_BO_ROL) B WHERE START_DATE <= %CurrentDateIn AND END_DATE >= %CurrentDateIn AND A.SETID = B.SETID AND A.RSP_PLAN_TYPE = B.RSP_PLAN_TYPE AND A.RSP_TEMPLATE_USAGE = 'A'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 SETID Character(5) VARCHAR2(5) NOT NULL This field is used to store the value of SetID on various setup tables.

2 ROLE_TYPE_ID Number(12,0) DECIMAL(12) NOT NULL Role Type ID

3 RSP_PLAN_TYPE_ACCT Character(15) VARCHAR2(15) NOT NULL This field is used by the Strategic Planning to define various plan types setup in the system.

4 RSP_UID20 Character(20) VARCHAR2(20) NOT NULL This field is used as a primary key in Strategic Planning header table (RSP_TP_HEADER)

5 RSP_NAME Character(50) VARCHAR2(50) NOT NULL Stores the Strategic plan / template name.

6 PERIOD_TYPE Character(1) VARCHAR2(1) NOT NULL Quota Definition Period Type
A=Annual
B=Bi-Weekly
D=Daily
M=Monthly
Q=Quarterly
S=Semi-Annual
W=Weekly

7 START_DATE Date(10) DATE Start Date for Gen Standing PO

8 END_DATE Date(10) DATE End date field to store an end date.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SETID	Character(5)	VARCHAR2(5) NOT NULL	This field is used to store the value of SetID on various setup tables.
2	ROLE_TYPE_ID	Number(12,0)	DECIMAL(12) NOT NULL	Role Type ID
3	RSP_PLAN_TYPE_ACCT	Character(15)	VARCHAR2(15) NOT NULL	This field is used by the Strategic Planning to define various plan types setup in the system.
4	RSP_UID20	Character(20)	VARCHAR2(20) NOT NULL	This field is used as a primary key in Strategic Planning header table (RSP_TP_HEADER)
5	RSP_NAME	Character(50)	VARCHAR2(50) NOT NULL	Stores the Strategic plan / template name.
6	PERIOD_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Quota Definition Period Type A=Annual B=Bi-Weekly D=Daily M=Monthly Q=Quarterly S=Semi-Annual W=Weekly
7	START_DATE	Date(10)	DATE	Start Date for Gen Standing PO
8	END_DATE	Date(10)	DATE	End date field to store an end date.