RB_SMS_REQST_SRCRB_INST_PROD_VW(SQL View) |
Index Back |
|---|---|
SMS Request SourceThis record holds the SMS Request Source description. |
| SELECT A.FIELDNAME ,C.LONGNAME ,C.SHORTNAME FROM PSRECFIELD A ,PSDBFIELD B , PSDBFLDLABL C WHERE A.RECNAME='INSTALLATION' AND B.FIELDTYPE=0 AND B.LENGTH=1 AND A.FIELDNAME=B.FIELDNAME AND B.FIELDNAME=C.FIELDNAME AND C.DEFAULT_LABEL=1 AND LENGTH(A.FIELDNAME)<=4 AND A.FIELDNAME NOT IN ('SUN','MON','TUES','WED','FRI','SAT','CDH') |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | RB_SMS_REQST_SRC |
Character(18) | VARCHAR2(18) NOT NULL | SMS request source application code |
| 2 | LONGNAME | Character(30) | VARCHAR2(30) NOT NULL | Long Name |
| 3 | SHORTNAME | Character(15) | VARCHAR2(15) NOT NULL | Field Short Name |