RSP_AUDN_TMPL_V(SQL View) |
Index Back |
---|---|
Templates Valid for AudienceThis record is used for prompting on the templates valid for Audience / Segment Planning |
SELECT A.SETID , B.RSP_PLAN_TYPE , RSP_UID20 , RSP_NAME , PERIOD_TYPE , START_DATE , END_DATE FROM %Table(RSP_TMPL_A_VW) A , %Table(RSP_PTYP_USAGE) B WHERE START_DATE <= %CurrentDateIn AND END_DATE >= %CurrentDateIn AND A.SETID = B.SETID AND A.RSP_PLAN_TYPE = B.RSP_PLAN_TYPE AND B.RSP_PLAN_USAGE = 'S' AND A.RSP_TEMPLATE_USAGE = 'S' |
# | 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 | RSP_PLAN_TYPE_AUDN | Character(15) | VARCHAR2(15) NOT NULL | This field is used by the Strategic Planning to define various plan types setup in the system. |
3 | RSP_UID20 | Character(20) | VARCHAR2(20) NOT NULL | This field is used as a primary key in Strategic Planning header table (RSP_TP_HEADER) |
4 | RSP_NAME | Character(50) | VARCHAR2(50) NOT NULL | Stores the Strategic plan / template name. |
5 | 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 |
6 | START_DATE | Date(10) | DATE | Start Date for Gen Standing PO |
7 | END_DATE | Date(10) | DATE | End date field to store an end date. |