INSTITUTIONSCC_TM_TASK_IDSCC_TM_TASKSVW(SQL View) |
Index Back |
|---|
| SELECT A.institution , A.scc_tm_task_id FROM %Table(SCC_TM_CONFIG) A WHERE %EffdtCheck(SCC_TM_CONFIG eff1 , A, %currentdatein) AND A.eff_status='A' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | INSTITUTION |
Character(5) | VARCHAR2(5) NOT NULL | Academic Institution |
| 2 | SCC_TM_TASK_ID |
Character(31) | VARCHAR2(31) NOT NULL | Template ID |