COLLECTION_SF

(SQL Table)
 Index Back

Collection Record

Table of students or organizations in Collection. Collection status tells if actively in collections.

  • Parent Record Of COLLECT_EFFORT COLL_LTR_ITEM

    • # 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
    3 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

    Prompt Table: PEOPLE_SRCH

    4 EXT_ORG_ID Character(11) VARCHAR2(11) NOT NULL External Org ID
    5 ORG_PERSON Character(1) VARCHAR2(1) NOT NULL Person or Organization
    O=Organization
    P=Person
    6 DATE_FROM Date(10) DATE Date From
    7 DATE_TO Date(10) DATE Previous Period Date To
    8 COLLECTION_STATUS Character(1) VARCHAR2(1) NOT NULL Collection Status
    A=Active being Collected
    C=Closed
    H=Hold All Collection Efforts
    I=Initial Collection Status
    N=Not Active Collected
    9 REASON_IN Character(3) VARCHAR2(3) NOT NULL Collection Reason In
    10 REASON_OUT Character(3) VARCHAR2(3) NOT NULL Collection Reason Out
    11 NEXT_REVIEW_DT Date(10) DATE Next Review Date
    12 NEXT_REVIEW_OPRID Character(30) VARCHAR2(30) NOT NULL Next Review User ID
    13 NEXT_REVIEW_ROLE Character(30) VARCHAR2(30) NOT NULL Next Review Role User
    14 COLLECTOR_OVERRIDE Character(30) VARCHAR2(30) NOT NULL Collector Override
    15 COLLECTOR_ASSIGNED Character(30) VARCHAR2(30) NOT NULL Collector Assigned

    Prompt Table: COLLECTOR_VW2

    16 ROLE_OVERRIDE Character(30) VARCHAR2(30) NOT NULL Role Override

    Prompt Table: COLLECT_ROLE_VW

    17 TEMPLATE_CODE Character(10) VARCHAR2(10) NOT NULL Template Code

    Prompt Table: COLL_LTRTMP_TBL

    18 MAILING_CD Character(1) VARCHAR2(1) NOT NULL Mailing Code
    C=Days in Collection
    D=Day of Month
    19 ADDR_USAGE Character(10) VARCHAR2(10) NOT NULL Address Usage

    Prompt Table: ADDR_USAGE_TBL

    20 NAME_TYPE Character(3) VARCHAR2(3) NOT NULL Type of Name

    Prompt Table: HCR_NM_TYP_I

    21 TEMPLATE_STATUS Character(1) VARCHAR2(1) NOT NULL Template Status
    C=Cancelled
    H=On Hold
    I=Initial
    P=In Progress
    T=Complete
    22 SERVICE_IMPACT Character(5) VARCHAR2(5) NOT NULL Service Impact

    Prompt Table: SRVC_IMPACT_TBL

    23 TEMPLATE_ASSIGN_DT Date(10) DATE Template Assign Date
    24 WL_FLAG Character(1) VARCHAR2(1) NOT NULL Worklist Flag

    Y/N Table Edit

    Default Value: N

    25 SSF_COLLECT_METHOD Character(1) VARCHAR2(1) NOT NULL Collection Placement Method
    C=Collection Process
    M=Manual

    Default Value: M