SAE_GRP_ROLETYPENOSAE_MEMBER_ROLEPrompt Table: SAE_IMSROLES
Prompt Table: SAE_IMSSUBROLES
SAE_GRPMEMROLES(SQL Table) |
Index Back |
|---|---|
Group Member RolesPrompt table for valid roles for SAIP Group Members |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SAE_GRP_ROLETYPENO |
Number(6,0) | INTEGER NOT NULL | Group Role Type Number Identifier |
| 2 | SAE_MEMBER_ROLE |
Character(30) | VARCHAR2(30) NOT NULL | SAIP Member Role |
| 3 | SAE_GRPMEMROLDESCR | Character(100) | VARCHAR2(100) NOT NULL | Group Member Role description |
| 4 | SAE_IMS_ROLE_NUM | Number(6,0) | INTEGER NOT NULL |
Role Number ID of corresponding role in IMS
Prompt Table: SAE_IMSROLES |
| 5 | SAE_IMS_SUBROLENUM | Number(6,0) | INTEGER NOT NULL |
Subrole number identifier for IMS subroles
Prompt Table: SAE_IMSSUBROLES |