RSP_AUDN_PTYP_V(SQL View) |
Index Back |
---|---|
Plan Types valid for AudienceThis record is used for prompting on the Plan Typesvalid for audience/segment planning |
SELECT A.SETID , A.RSP_PLAN_TYPE , A.DESCR FROM %Table(RSP_PLAN_TYPE) A , %Table(RSP_PTYP_USAGE) B WHERE A.SETID = B.SETID AND A.RSP_PLAN_TYPE = B.RSP_PLAN_TYPE AND B.RSP_PLAN_USAGE = 'S' AND A.STATUS = '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 | RSP_PLAN_TYPE | Character(15) | VARCHAR2(15) NOT NULL | This field is used by the Strategic Planning to define various plan types setup in the system. |
3 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |