EMPLIDPrompt Table: PERSONAL_DATA
AWARD_CODEPrompt Table: %EDITTABLE
GM_PERS_HA_VW(SQL View) |
Index Back |
|---|---|
Honors/Awards ViewUse HONOR_AWARD to record an employee's honors and awards. This view identifies the unique honors/awards associated with a professional. |
| select B.EMPLID ,B.AWARD_CODE ,B.DT_RECVD ,C.DESCR ,C.DESCRFORMAL ,B.GRANTOR ,B.COMMENTS From PS_GM_PERS_HON_AWD B, PS_GM_HON_AWD_TBL C Where B.AWARD_CODE=C.AWARD_CODE And C.EFFDT=(select max(C1.EFFDT) from PS_GM_HON_AWD_TBL C1 Where C1.AWARD_CODE=C.AWARD_CODE And C1.EFFDT <= %currentdatein) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL |
Employee ID
Prompt Table: PERSONAL_DATA |
| 2 | AWARD_CODE |
Character(6) | VARCHAR2(6) NOT NULL |
Honor/Award
Prompt Table: %EDITTABLE |
| 3 | DT_RECVD | Date(10) | DATE NOT NULL | Date Received |
| 4 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 5 | DESCRFORMAL | Character(50) | VARCHAR2(50) NOT NULL | Formal Description |
| 6 | GRANTOR | Character(20) | VARCHAR2(20) NOT NULL | Grantor |
| 7 | COMMENTS | Long Character | CLOB | Comment |