TMPLT_CATEGRY_IDTMPLT_TYPE_IDRB_SMS_TMPL_NAMERB_SMS_PICK_VW(SQL View) |
Index Back |
|---|---|
SMS Template pick treeSMS Template pick tree SQL view |
| SELECT TMPLT_CATEGRY_ID ,TMPLT_TYPE_ID ,B.RB_SMS_TMPL_NAME ,A.RB_SMS_TMPL_ID FROM PS_RB_TMPL_CAT_TYP A ,PS_RB_SMS_TMPL_DFN B WHERE A.RB_SMS_TMPL_ID=B.RB_SMS_TMPL_ID AND B.RB_SMS_TMPL_STATUS='A' AND RB_SMS_MSG_CONTENT <> ' ' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | TMPLT_CATEGRY_ID |
Number(6,0) | INTEGER NOT NULL | Template Category ID |
| 2 | TMPLT_TYPE_ID |
Number(6,0) | INTEGER NOT NULL | Template Type ID |
| 3 | RB_SMS_TMPL_NAME |
Character(80) | VARCHAR2(80) NOT NULL | SMS template name |
| 4 | RB_SMS_TMPL_ID | Number(18,0) | DECIMAL(18) NOT NULL | SMS Template ID |