SERVICER_VW

(SQL View)
 Index Back

Servicer Table Vw

Record used to define loan Destination (external Processor/Servicer) information and processing options, by Aid Year.

SELECT SERV_UNQ_ID , SERV_OE_CD , SERV_OE_BRNCH , DESCR FROM PS_SERVICER_TBL

  • Related Language Record: SERVICER_VW_LN

  • Parent record: AID_YEAR_TBL

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SERV_UNQ_ID Number(3,0) SMALLINT NOT NULL Servicer ID

    Prompt Table: SERVICER_TBL

    2 SERV_OE_CD Character(6) VARCHAR2(6) NOT NULL Destination OE Code
    3 SERV_OE_BRNCH Character(4) VARCHAR2(4) NOT NULL Destination OE Branch

    Default Value: 0000

    4 DESCR Character(30) VARCHAR2(30) NOT NULL Description