SCC_SUM_CFG(SQL Table) |
Index Back |
|---|
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SCC_SUM_TABLBL_SC | Character(20) | VARCHAR2(20) NOT NULL | Student Center |
| 2 | SCC_SUM_TABPOS_SC | Number(1,0) | SMALLINT NOT NULL | Tab Position |
| 3 | SCC_SUM_TABLBL_CC | Character(20) | VARCHAR2(20) NOT NULL | General Information |
| 4 | SCC_SUM_TABPOS_CC | Number(1,0) | SMALLINT NOT NULL |
Tab Position
Default Value: 1 |
| 5 | SCC_SUM_TABLBL_AD | Character(20) | VARCHAR2(20) NOT NULL | Admissions |
| 6 | SCC_SUM_TABPOS_AD | Number(1,0) | SMALLINT NOT NULL |
Tab Position
Default Value: 2 |
| 7 | SCC_SUM_TABLBL_SR | Character(20) | VARCHAR2(20) NOT NULL | Academic Records |
| 8 | SCC_SUM_TABPOS_SR | Number(1,0) | SMALLINT NOT NULL |
Tab Position
Default Value: 4 |
| 9 | SCC_SUM_TABLBL_SF | Character(20) | VARCHAR2(20) NOT NULL | Student Financial |
| 10 | SCC_SUM_TABPOS_SF | Number(1,0) | SMALLINT NOT NULL |
Tab Position
Default Value: 5 |
| 11 | SCC_SUM_TABLBL_FA | Character(20) | VARCHAR2(20) NOT NULL | Financial Aid |
| 12 | SCC_SUM_TABPOS_FA | Number(1,0) | SMALLINT NOT NULL |
Tab Position
Default Value: 6 |
| 13 | SCC_SUM_TABLBL_TC | Character(20) | VARCHAR2(20) NOT NULL | Transfer Credit |
| 14 | SCC_SUM_TABPOS_TC | Number(1,0) | SMALLINT NOT NULL |
Tab Position
Default Value: 3 |
| 15 | SCC_SUM_CC_010 | Character(1) | VARCHAR2(1) NOT NULL |
Service Indicators
Y/N Table Edit Default Value: Y |
| 16 | SCC_SUM_CC_020 | Character(1) | VARCHAR2(1) NOT NULL |
Initiated Checklists
Y/N Table Edit Default Value: Y |
| 17 | SCC_SUM_CC_030 | Character(1) | VARCHAR2(1) NOT NULL |
Student Groups
Y/N Table Edit Default Value: Y |
| 18 | SCC_SUM_CC_040 | Character(1) | VARCHAR2(1) NOT NULL |
Personal Data
Y/N Table Edit Default Value: Y |
| 19 | SCC_SUM_CC_050 | Character(1) | VARCHAR2(1) NOT NULL |
National ID
Y/N Table Edit Default Value: Y |
| 20 | SCC_SUM_CC_060 | Character(1) | VARCHAR2(1) NOT NULL |
Names
Y/N Table Edit Default Value: Y |
| 21 | SCC_SUM_CC_070 | Character(1) | VARCHAR2(1) NOT NULL |
Addresses
Y/N Table Edit Default Value: Y |
| 22 | SCC_SUM_CC_080 | Character(1) | VARCHAR2(1) NOT NULL |
Phones
Y/N Table Edit Default Value: Y |
| 23 | SCC_SUM_CC_090 | Character(1) | VARCHAR2(1) NOT NULL |
Email Addresses
Y/N Table Edit Default Value: Y |
| 24 | SCC_SUM_AD_010 | Character(1) | VARCHAR2(1) NOT NULL |
Application Data
Y/N Table Edit Default Value: Y |
| 25 | SCC_SUM_AD_020 | Character(1) | VARCHAR2(1) NOT NULL |
Applicant Progression
Y/N Table Edit Default Value: Y |
| 26 | SCC_SUM_AD_030 | Character(1) | VARCHAR2(1) NOT NULL |
External Education
Y/N Table Edit Default Value: Y |
| 27 | SCC_SUM_AD_040 | Character(1) | VARCHAR2(1) NOT NULL |
Test Summary
Y/N Table Edit Default Value: Y |
| 28 | SCC_SUM_AD_050 | Character(1) | VARCHAR2(1) NOT NULL |
Application Recruiters
Y/N Table Edit Default Value: Y |
| 29 | SCC_SUM_TC_010 | Character(1) | VARCHAR2(1) NOT NULL |
Course Credits
Y/N Table Edit Default Value: Y |
| 30 | SCC_SUM_TC_020 | Character(1) | VARCHAR2(1) NOT NULL |
Test Credits
Y/N Table Edit Default Value: Y |
| 31 | SCC_SUM_TC_030 | Character(1) | VARCHAR2(1) NOT NULL |
Other Credits
Y/N Table Edit Default Value: Y |
| 32 | SCC_SUM_SR_010 | Character(1) | VARCHAR2(1) NOT NULL |
Student Program Data
Y/N Table Edit Default Value: Y |
| 33 | SCC_SUM_SR_020 | Character(1) | VARCHAR2(1) NOT NULL |
Term Summary
Y/N Table Edit Default Value: Y |
| 34 | SCC_SUM_SR_030 | Character(1) | VARCHAR2(1) NOT NULL |
Student Enrollment
Y/N Table Edit Default Value: Y |
| 35 | SCC_SUM_SR_040 | Character(1) | VARCHAR2(1) NOT NULL |
Term History
Y/N Table Edit Default Value: Y |
| 36 | SCC_SUM_SF_010 | Character(1) | VARCHAR2(1) NOT NULL |
Tuition Calculation
Y/N Table Edit |
| 37 | SCC_SUM_SF_020 | Character(1) | VARCHAR2(1) NOT NULL |
Due Charges
Y/N Table Edit |
| 38 | SCC_SUM_SF_030 | Character(1) | VARCHAR2(1) NOT NULL |
Refunds
Y/N Table Edit |
| 39 | SCC_SUM_SF_040 | Character(1) | VARCHAR2(1) NOT NULL |
Bills
Y/N Table Edit |
| 40 | SCC_SUM_SF_050 | Character(1) | VARCHAR2(1) NOT NULL |
Payment Plans
Y/N Table Edit |
| 41 | SCC_SUM_SF_060 | Character(1) | VARCHAR2(1) NOT NULL |
Credit History and Collection
Y/N Table Edit |
| 42 | SCC_SUM_SF_070 | Character(1) | VARCHAR2(1) NOT NULL |
Override Student Waiver
Y/N Table Edit Default Value: N |
| 43 | SCC_SUM_FA_010 | Character(1) | VARCHAR2(1) NOT NULL | Financial Aid Status |
| 44 | SCC_SUM_FA_020 | Character(1) | VARCHAR2(1) NOT NULL | Award Summary |
| 45 | SCC_SUM_FA_030 | Character(1) | VARCHAR2(1) NOT NULL | Term Summary |