SSR_RS_REQTYVW1

(SQL View)
Index Back

Service Request Type View

Prompt for Service Request Types

SELECT A.institution , 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_TM_SS_LBL = 'Y'

# 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_RQUEST_TYPE Character(5) VARCHAR2(5) NOT NULL Service Request Type
3 DESCR100 Character(100) VARCHAR2(100) NOT NULL Length 100 Description
4 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description