QCTMPL_IDROLE_SEQ_NBRRBQ_QCTMPLRL_VW(SQL View) |
Index Back |
|---|---|
Quick Create Template Role VwQuick Create Template Role View for prompt on Roles |
| SELECT QCTMPL_ID , ROLE_SEQ_NBR , LABEL30 , ROLE_TYPE_ID FROM %Table(RBQ_QCTMPL_RL) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | QCTMPL_ID |
Character(20) | VARCHAR2(20) NOT NULL | Quick Create Template ID |
| 2 | ROLE_SEQ_NBR |
Number(3,0) | SMALLINT NOT NULL | Role Sequence Number |
| 3 | LABEL30 | Character(30) | VARCHAR2(30) NOT NULL | Label Description 30 char |
| 4 | ROLE_TYPE_ID | Number(12,0) | DECIMAL(12) NOT NULL | Role Type ID |