SRVC_IND_DSB_VW(SQL View) |
Index Back |
---|---|
Service Indicator Code View FAThis 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 |