SSR_RS_REQTYPVW

(SQL View)
Index Back

Service Request Type View

Prompt for Service Request Types

SELECT A.institution , A.ssr_Rs_request_cat , A.ssr_rs_rquest_type , A.descr100 , A.descrshort FROM %Table(ssr_rs_reqsttyp) A WHERE %EffdtCheck(ssr_rs_reqsttyp B, A, %CurrentDateIn) AND A.eff_status='A' AND A.ssr_Rs_request_cat <> ' '

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution

Default Value: OPR_DEF_TBL_CS.INSTITUTION

Prompt Table: INSTITUTION_TBL

2 SSR_RS_REQUEST_CAT Character(10) VARCHAR2(10) NOT NULL Service Request Category
3 SSR_RS_RQUEST_TYPE Character(5) VARCHAR2(5) NOT NULL Service Request Type
4 DESCR100 Character(100) VARCHAR2(100) NOT NULL Length 100 Description
5 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description