GENL_COMMENT(SQL Table) |
Index Back |
|---|---|
ER CommentsUse GENL_COMMENT to enter any general comments that you wish to retain relating to an employee's job or employment. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | Character(11) | VARCHAR2(11) NOT NULL |
Employee ID
Prompt Table: PERSON |
|
| 2 | COMMENT_DT | Date(10) | DATE | Comment Date |
| 3 | COMMENTS_BY_NAME | Character(50) | VARCHAR2(50) NOT NULL | Comments By |
| 4 | COMMENTS | Long Character | CLOB | Comment |