INSTITUTIONPrompt Table: INSTITUTION_TBL
INTERNAL_EXTERNALE=External
I=Internal
AWARD_CODEEFFDTDefault Value: %date
LANGUAGE_CDHONAWRDEXTVWLNG(SQL View) |
Index Back |
|---|---|
External Honors/Awards ViewHONAWRDEXTVWLNG is the language record related to HON_AWRD_EXT_VW A related language record enables text fields on a table to be translated into various languages for use in other countries. |
| SELECT a.institution ,b.internal_external ,a.award_code ,a.effdt ,a.language_cd ,a.descr FROM ps_honor_award_lng a , PS_HONOR_AWARD_TBL b WHERE a.institution = b.institution AND a.award_code = b.award_code AND a.effdt = b.effdt AND b.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 | LANGUAGE_CD |
Character(3) | VARCHAR2(3) NOT NULL | Language Code |
| 6 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |