SRVC_IND_DSB_VW

(SQL View)
Index Back

Service Indicator Code View FA

This table maintains all service indicator codes. Its positive service indicator determines whether enhanced services are provided. It's child record, Service Impact, contains the services that are impacted.

SELECT DISTINCT a.srvc_ind_cd , a.descr , a.dflt_srvc_ind_rsn FROM PS_SRVC_IND_CD_TBL a WHERE a.effdt=( SELECT MAX(b.effdt) FROM PS_SRVC_IND_CD_TBL b WHERE a.institution=b.institution AND a.srvc_ind_cd = b.srvc_ind_cd AND a.effdt=b.effdt AND b.eff_status='A')

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 SRVC_IND_CD Character(3) VARCHAR2(3) NOT NULL Service Indicator Cd
2 DESCR Character(30) VARCHAR2(30) NOT NULL Description
3 DFLT_SRVC_IND_RSN Character(5) VARCHAR2(5) NOT NULL Default Reason

Prompt Table: SRVC_IN_RSN_TBL