INSTITUTIONPrompt Table: INSTITUTION_TBL
A=Add
C=Change
D=Delete
Y/N Table Edit
Y/N Table Edit
Default Value: N
Y/N Table Edit
Default Value: N
SAE_INST_SCO_VW(SQL View) |
Index Back |
|---|
| SELECT INSTITUTION , SAE_START_OFFSET , SAE_END_OFFSET , SAE_MODE , SAE_EVENT_DT , SAE_DEF_INCLUDE , SAE_DEF_CLS_ASSOC , SAE_DEF_COMB_SEC , SAE_LAST_SET_TIME ,SAE_LAST_CMND_TIME FROM %Table(SAE_INST_SCOPE) 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: INSTITUTION_TBL |
| 2 | SAE_START_OFFSET | Signed Number(7,0) | DECIMAL(6) NOT NULL | Integration Start Date Offset |
| 3 | SAE_END_OFFSET | Signed Number(7,0) | DECIMAL(6) NOT NULL | Integration End Date Offset |
| 4 | SAE_MODE | Character(1) | VARCHAR2(1) NOT NULL |
Operation Mode
A=Add C=Change D=Delete |
| 5 | SAE_EVENT_DT | DateTime(26) | TIMESTAMP | Event Driven Timestamp |
| 6 | SAE_DEF_INCLUDE | Character(1) | VARCHAR2(1) NOT NULL |
Default in Scope
Y/N Table Edit |
| 7 | SAE_DEF_CLS_ASSOC | Character(1) | VARCHAR2(1) NOT NULL |
IMS association from Class
Y/N Table Edit Default Value: N |
| 8 | SAE_DEF_COMB_SEC | Character(1) | VARCHAR2(1) NOT NULL |
Associate Cross Listed Courses
Y/N Table Edit Default Value: N |
| 9 | SAE_LAST_SET_TIME | DateTime(26) | TIMESTAMP | When Set All In Scope selected |
| 10 | SAE_LAST_CMND_TIME | DateTime(26) | TIMESTAMP | Last combined time |