SCC_TM_CFG_ADDR(SQL Table) |
Index Back |
|---|---|
Task Config Launch Address |
| # | 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
Prompt Table: PTAI_TMPL_PVW |
| 3 | EFFDT |
Date(10) | DATE NOT NULL |
Effective Date
Default Value: %date |
| 4 | SCC_TM_PG_SUBTYPE |
Character(4) | VARCHAR2(4) NOT NULL |
Region
ADDR=Addresses CAR=Career EMAL=Email Addresses EMRG=Emergency Contacts PHON=Phone Numbers Default Value: CAR |
| 5 | SSS_SC_ADDR_BOX1 | Character(4) | VARCHAR2(4) NOT NULL |
Address Box 1 (left)
Prompt Table: ADDRESS_TYP_TBL |
| 6 | SSS_SC_ADDR1_LBL | Character(30) | VARCHAR2(30) NOT NULL | Address Box 1 Link Label |
| 7 | SSS_SC_ADDR_BOX2 | Character(4) | VARCHAR2(4) NOT NULL |
Address Box 2 (right)
Prompt Table: ADDRESS_TYP_TBL |
| 8 | SSS_SC_ADDR2_LBL | Character(30) | VARCHAR2(30) NOT NULL | Address Box 2 Link Label |
| 9 | SCC_ROW_ADD_OPRID | Character(30) | VARCHAR2(30) NOT NULL | Created By |
| 10 | SCC_ROW_ADD_DTTM | DateTime(26) | TIMESTAMP | Created |
| 11 | SCC_ROW_UPD_OPRID | Character(30) | VARCHAR2(30) NOT NULL | Updated By |
| 12 | SCC_ROW_UPD_DTTM | DateTime(26) | TIMESTAMP | Last Update Date/Time |