PERSON_CHK_ITEM

(SQL Table)
 Index Back

Person Checklist Item

PERSON_CHK_ITEM stores the items associated with a person's checklist. There is one record in this table for each item or sequence number within a dated list.

  • Parent record: PERSON_CHECKLST

    • # 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
    2 SEQ_3C Number(5,0) INTEGER NOT NULL Sequence Number

    Default Value: 99999

    3 CHECKLIST_SEQ Number(6,0) INTEGER NOT NULL Checklist Sequence
    4 CHKLST_ITEM_CD Character(6) VARCHAR2(6) NOT NULL Checklist Item Code

    Prompt Table: CHKLST_ITEM_VW

    5 ITEM_STATUS Character(1) VARCHAR2(1) NOT NULL Item Status
    A=Active
    C=Completed
    I=Initiated
    N=Notified
    O=Ordered
    P=Paid Off
    R=Received
    S=Second Notification
    T=Returned
    W=Waived
    X=Cancelled

    Default Value: I

    6 STATUS_DT Date(10) DATE NOT NULL Status Date

    Default Value: PERSON_CHECKLST.STATUS_DT

    7 STATUS_CHANGE_ID Character(11) VARCHAR2(11) NOT NULL Status Change ID

    Default Value: PERSON_CHECKLST.STATUS_CHANGE_ID

    Prompt Table: PEOPLE_SRCH

    8 DUE_DT Date(10) DATE NOT NULL Due Date
    9 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

    Prompt Table: CURRENCY_CD_TBL

    10 DUE_AMT Signed Number(18,2) DECIMAL(16,2) NOT NULL Due Amount
    11 RESPONSIBLE_ID Character(11) VARCHAR2(11) NOT NULL Responsible ID

    Default Value: PERSON_CHK_ITEM.STATUS_CHANGE_ID

    Prompt Table: PEOPLE_SRCH

    12 ASSOC_ID Character(11) VARCHAR2(11) NOT NULL Association ID
    13 NAME Character(50) VARCHAR2(50) NOT NULL Name
    14 COMM_KEY Character(8) VARCHAR2(8) NOT NULL Communication Speed Key