PERSON_COMMENT

(SQL Table)
Index Back

Person Comment

PERSON_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.

  • Parent record: PERSON
  • # 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
    Set Control Field: INSTITUTION

    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