SCC_WSC_COMMUN(SQL Table) |
Index Back |
|---|---|
HE Configuration page |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | ADDRESS1 | Character(55) | VARCHAR2(55) NOT NULL |
Address 1
Prompt Table: ADDR_USAGE_TBL |
| 2 | SCC_EMAIL | Character(10) | VARCHAR2(10) NOT NULL |
Email Usage
Prompt Table: ADDR_USAGE_TBL |
| 3 | PHONE | Character(24) | VARCHAR2(24) NOT NULL |
Telephone
Prompt Table: PHONE_USAGE_TBL |
| 4 | SCC_3C | Character(1) | VARCHAR2(1) NOT NULL |
3C Period selection
A=Include All P=Include previous month(s) |
| 5 | SCC_3C_PERIOD | Number(3,0) | SMALLINT NOT NULL | 3C Period |
| 6 | SCC_FA | Character(1) | VARCHAR2(1) NOT NULL |
FA Year Selection
A=Include All S=Selected Financial Aid Year(s) |
| 7 | SCC_CR1 | Character(1) | VARCHAR2(1) NOT NULL |
CR Relationship Selection
A=Include All Relationships S=Selected Relationship(S) |
| 8 | SCC_DATETIME_UPD | DateTime(26) | TIMESTAMP | Last Date Time Updated |
| 9 | SCC_MOD_OPR | Character(5) | VARCHAR2(5) NOT NULL | Last Modified Operator Id |