SRVC_IND_CD_TBL(SQL Table) |
Index Back |
|---|---|
Service Indicator Code TableThis 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. |
| # | 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 | SRVC_IND_CD |
Character(3) | VARCHAR2(3) NOT NULL | Service Indicator Cd |
| 3 | EFFDT |
Date(10) | DATE NOT NULL |
Effective Date
Default Value: %date |
| 4 | EFF_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Effective Status
A=Active I=Inactive Default Value: A |
| 5 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 6 | DESCRSHORT | Character(10) | VARCHAR2(10) NOT NULL |
Short Description
Default Value: SRVC_IND_CD_TBL.DESCR |
| 7 | POS_SRVC_INDICATOR | Character(1) | VARCHAR2(1) NOT NULL |
Positive Service Indicator
Y/N Table Edit Default Value: N |
| 8 | SCC_HOLD_DISPLAY | Character(1) | VARCHAR2(1) NOT NULL |
Service Indicator attribute - display in Self-Service
Y/N Table Edit Default Value: N |
| 9 | SCC_SI_PERS | Character(1) | VARCHAR2(1) NOT NULL |
Service Indicator attribute - is this Service Indicator Code for person?
Y/N Table Edit Default Value: N |
| 10 | SCC_SI_ORG | Character(1) | VARCHAR2(1) NOT NULL |
Service Indicator attribute - is this service indicator code for external organizations?
Y/N Table Edit Default Value: N |
| 11 | SCC_DFLT_ACTDATE | Character(1) | VARCHAR2(1) NOT NULL |
Service Indicator attribute - set default active date
Y/N Table Edit Default Value: N |
| 12 | SCC_DFLT_ACTTERM | Character(1) | VARCHAR2(1) NOT NULL |
Service Indicator attribute - set default active term
Y/N Table Edit Default Value: N |
| 13 | DFLT_SRVC_IND_RSN | Character(5) | VARCHAR2(5) NOT NULL |
Default Reason
Prompt Table: SRVC_IN_RSN_TBL |
| 14 | SRV_IND_DCSD_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Display Deceased Label
Y/N Table Edit |