EMPLIDPrompt Table: PERSONAL_DATA
AWARD_CODEPrompt Table: GM_HON_AWD_TBL
DT_RECVDGM_PERS_HON_AWD(SQL Table) |
Index Back |
|---|---|
Grants Honors/Awards InstUse HONOR_AWARD to record an employee's honors and awards. You can create multiple HONOR_AWARD records for an employee. |
| # | 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: GM_HON_AWD_TBL |
| 3 | DT_RECVD |
Date(10) | DATE | Date Received |
| 4 | GRANTOR | Character(20) | VARCHAR2(20) NOT NULL | Grantor |
| 5 | REASON_CONFERRED | Character(30) | VARCHAR2(30) NOT NULL | Reason Conferred |
| 6 | COMMENTS | Long Character | CLOB | Comment |