INSTITUTIONSSR_RS_REQUEST_CATSSR_RS_REQCATVW(SQL View) |
Index Back |
|---|---|
Service Request Category promp |
| SELECT A.INSTITUTION , A.SSR_RS_REQUEST_CAT , A.DESCR100 ,A.SSR_ORDER_NBR ,A.MESSAGE_NBR ,A.MESSAGE_SET_NBR FROM %Table(SSR_RS_REQSTCAT) A WHERE %EffdtCheck(SSR_RS_REQSTCAT eff1,A,%currentdatein) AND A.EFF_STATUS='A' AND EXISTS( SELECT 'X' FROM %Table(SSR_RS_REQSTTYP) B WHERE A.INSTITUTION = B.INSTITUTION AND A.SSR_RS_REQUEST_CAT = B.SSR_RS_REQUEST_CAT AND %EffdtCheck(SSR_RS_REQSTTYP eff2,B,%Currentdatein) AND B.EFF_STATUS='A' ) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | INSTITUTION |
Character(5) | VARCHAR2(5) NOT NULL | Academic Institution |
| 2 | SSR_RS_REQUEST_CAT |
Character(10) | VARCHAR2(10) NOT NULL | Service Request Category |
| 3 | DESCR100 | Character(100) | VARCHAR2(100) NOT NULL | Length 100 Description |
| 4 | SSR_ORDER_NBR | Number(3,0) | SMALLINT NOT NULL | Order Number |
| 5 | MESSAGE_NBR | Number(5,0) | INTEGER NOT NULL | Message Number. This field refers to the Message Number in the Message Catalog. |
| 6 | MESSAGE_SET_NBR | Number(5,0) | INTEGER NOT NULL | Message Set Number. This field refers to the Message Set Number in the Message Catalog. |