COLL_LTR_ITEM

(SQL Table)
 Index Back

Collection Letter Item

  • Parent record: COLLECTION_SF

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

    Prompt Table: SP_BU_SF_NONVW

    2 COLLECTION_ID Number(12,0) DECIMAL(12) NOT NULL Collection ID

    Prompt Table: COLLECTION_SF

    3 SEQ_NO Number(2,0) SMALLINT NOT NULL Sequence Number
    4 SCC_LETTER_CD Character(3) VARCHAR2(3) NOT NULL Letter Code

    Prompt Table: COMM_CTX_ME_OVW

    5 DAYS_IN_COLLECTION Number(3,0) SMALLINT NOT NULL Days in Collections
    6 START_DATE Date(10) DATE Start Date for Gen Standing PO
    7 MAIL_STATUS Character(1) VARCHAR2(1) NOT NULL Mail Status
    C=Cancelled
    P=Pending
    S=Communication Initiated

    Default Value: P

    8 COMM_DTTM DateTime(26) TIMESTAMP Communication DateTime
    9 ADMIN_FUNCTION Character(4) VARCHAR2(4) NOT NULL Administrative Function

    Prompt Table: ADM_FUNCTN_TBL

    10 COMM_CATEGORY Character(6) VARCHAR2(6) NOT NULL Communication Category

    Prompt Table: COMM_CATG_SFVW

    11 COMM_CONTEXT Character(6) VARCHAR2(6) NOT NULL Communication Context

    Prompt Table: COMM_CTXT_SFVW

    12 COMM_METHOD Character(1) VARCHAR2(1) NOT NULL Communication Method
    B=Publication
    D=Document
    E=Email
    F=Fax
    L=Letter
    P=Personal Contact
    T=Telephone Call
    W=Web

    Default Value: L

    13 DEPTID Character(10) VARCHAR2(10) NOT NULL Department

    Prompt Table: HCR_DEPT_I