RC_REVTYPE_SS(SQL View) |
Index Back |
---|---|
Review Type for FeedbackView shows only the review types that can be displayed in Feedback pages. |
SELECT SETID ,RC_DESCR_SS ,RC_REVIEW_TYPE ,RC_SS_IND FROM PS_RC_REV_TYPE_TBL WHERE RC_SS_IND = 'Y' |
# | 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.
Default Value: OPR_DEF_TBL_RB.SETID Prompt Table: SP_SETID_NONVW |
2 | RC_DESCR_SS | Character(30) | VARCHAR2(30) NOT NULL | Description to be shown on Self-Service Pages |
3 | RC_REVIEW_TYPE | Character(5) | VARCHAR2(5) NOT NULL | Case severity |
4 | RC_SS_IND | Character(1) | VARCHAR2(1) NOT NULL |
Defines if this is a self service transaction or not.
Y/N Table Edit Default Value: Y |