PERSON_COMMENT(SQL Table) |
Index Back |
---|---|
Person CommentPERSON_COMMENT is used to record free-form comments made about a person. These comments may be shared or restricted based on user-defined Inquiry Groups. |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | COMMON_ID | Character(11) | VARCHAR2(11) NOT NULL |
Common ID to store Personal ID / Ext Org ID value
Prompt Table: PEOPLE_SRCH |
2 | SEQ_3C | Number(5,0) | INTEGER NOT NULL |
Sequence Number
Default Value: 99999 |
3 | SA_ID_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
ID Type
O=Organization P=Person |
4 | COMMENT_DTTM | DateTime(26) | TIMESTAMP NOT NULL |
Comment DateTime
Default Value: %date |
5 | ADMIN_FUNCTION | Character(4) | VARCHAR2(4) NOT NULL |
Administrative Function
Prompt Table: %EDITTABLE15 |
6 | CMNT_CATEGORY | Character(6) | VARCHAR2(6) NOT NULL |
Comment Category
Prompt Table: CMNT_CATG_VW |
7 | DEPTID | Character(10) | VARCHAR2(10) NOT NULL |
Department
Default Value: OPR_DEF_TBL_CS.DEPTID Prompt Table:
SCC_DEPT_TBL_VW
|
8 | CMNT_ID | Character(11) | VARCHAR2(11) NOT NULL |
Comment ID
Prompt Table: PEOPLE_SRCH |
9 | COMMENT_DT | Date(10) | DATE |
Comment Date
Default Value: %date |
10 | INSTITUTION | Character(5) | VARCHAR2(5) NOT NULL |
Academic Institution
Default Value: OPR_DEF_TBL_CS.INSTITUTION Prompt Table: INSTITUTION_TBL |
11 | VAR_DATA_SEQ | Number(4,0) | SMALLINT NOT NULL | Variable Data Sequence Number |
12 | COMMENTS | Long Character | CLOB | Comment |