SAE_GROUP_NOEMPLIDPrompt Table: PEOPLE_SRCH
SAE_MEMBER_ROLEPrompt Table: SAE_GRPMEMROLES
A=Active
I=Inactive
Default Value: A
ADD=Add
DEL=Delete
SAE_GRP_MEMBERS(SQL Table) |
Index Back |
|---|
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SAE_GROUP_NO |
Number(6,0) | INTEGER NOT NULL | Group Number identifier |
| 2 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL |
Employee ID
Prompt Table: PEOPLE_SRCH |
| 3 | SAE_MEMBER_ROLE |
Character(30) | VARCHAR2(30) NOT NULL |
SAIP Member Role
Prompt Table: SAE_GRPMEMROLES |
| 4 | SAE_GRP_MEM_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Group Member Status
A=Active I=Inactive Default Value: A |
| 5 | SAE_MEM_BEGIN_DT | Date(10) | DATE | SAIP Member Begin Date |
| 6 | SAE_MEM_END_DT | Date(10) | DATE | SAIP Member End Date |
| 7 | SAE_MEM_OVERRIDE | Character(4) | VARCHAR2(4) NOT NULL |
SAIP Membership Override
ADD=Add DEL=Delete |