EXT_SUMM_TYPEEFFDTDefault Value: %date
A=Active
I=Inactive
Default Value: A
Default Value: EXT_SUMM_TP_TBL.DESCR
EXT_SUMM_TP_TBL(SQL Table) |
Index Back |
|---|---|
External Summary Type TableSUMM_TYPE_TBL is a prompt table. This table lists only the Program Actions that are valid for Admissions. When an Admissions operator prompts on Program Action in the Applicant Program record they will be prompting against this table and see only valid Admissions Actions. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EXT_SUMM_TYPE |
Character(4) | VARCHAR2(4) NOT NULL | Summary Type |
| 2 | EFFDT |
Date(10) | DATE NOT NULL |
Effective Date
Default Value: %date |
| 3 | EFF_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Effective Status
A=Active I=Inactive Default Value: A |
| 4 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 5 | DESCRSHORT | Character(10) | VARCHAR2(10) NOT NULL |
Short Description
Default Value: EXT_SUMM_TP_TBL.DESCR |