INSTITUTIONPrompt Table: SAE_INST_SCOPE
ACAD_ORGPrompt Table: ACAD_ORG_TBL_VW
A=Add
C=Change
D=Delete
Y/N Table Edit
Default Value: N
Y/N Table Edit
SAE_ACAD_EXT_VW(SQL View) |
Index Back |
|---|
| SELECT INSTITUTION , ACAD_ORG , SAE_MODE , SAE_EVENT_DT , SAE_DEF_INCLUDE , SAE_DEF_CLS_ASSOC , SAE_LAST_SET_TIME FROM %Table(SAE_ACADORG_EXT) WHERE SAE_MODE <> 'D' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | INSTITUTION |
Character(5) | VARCHAR2(5) NOT NULL |
Academic Institution
Prompt Table: SAE_INST_SCOPE |
| 2 | ACAD_ORG |
Character(10) | VARCHAR2(10) NOT NULL |
Academic Organization
Prompt Table: ACAD_ORG_TBL_VW |
| 3 | SAE_MODE | Character(1) | VARCHAR2(1) NOT NULL |
Operation Mode
A=Add C=Change D=Delete |
| 4 | SAE_EVENT_DT | DateTime(26) | TIMESTAMP | Event Driven Timestamp |
| 5 | SAE_DEF_INCLUDE | Character(1) | VARCHAR2(1) NOT NULL |
Default in Scope
Y/N Table Edit Default Value: N |
| 6 | SAE_DEF_CLS_ASSOC | Character(1) | VARCHAR2(1) NOT NULL |
IMS association from Class
Y/N Table Edit |
| 7 | SAE_LAST_SET_TIME | DateTime(26) | TIMESTAMP | When Set All In Scope selected |