INSTITUTIONPrompt Table: INSTITUTION_TBL
INTERNAL_EXTERNALE=External
I=Internal
AWARD_CODEEFFDTDefault Value: %date
A=Active
I=Inactive
HON_AWRD_EXT_VW(SQL View) |
Index Back |
|---|---|
External Honors/Awards View |
| select a.institution ,a.internal_external ,a.award_code ,a.effdt ,a.eff_status ,a.descr from PS_HONOR_AWARD_TBL a where internal_external = 'E' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | INSTITUTION |
Character(5) | VARCHAR2(5) NOT NULL |
Academic Institution
Prompt Table: INSTITUTION_TBL |
| 2 | INTERNAL_EXTERNAL |
Character(1) | VARCHAR2(1) NOT NULL |
Internal/External
E=External I=Internal |
| 3 | AWARD_CODE |
Character(6) | VARCHAR2(6) NOT NULL | Award Code |
| 4 | EFFDT |
Date(10) | DATE |
Effective Date
Default Value: %date |
| 5 | EFF_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Effective Status
A=Active I=Inactive |
| 6 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |