SFA_CRC_DEST_VW

(SQL View)
 Index Back

Loan Destination Profile View

Selects the current active Loan Destination Profile Information

SELECT A.INSTITUTION ,A.LOAN_PROGRAM ,A.LN_DEST_NBR ,A.DESCR ,A.DESCRSHORT ,A.INC_DEST_OVR ,A.SFA_CR_LNDR_OPEID ,A.SFA_CR_LNDR_BRANCH ,A.SFA_CR_GUAR_OPEID ,A.SFA_CR_GUAR_BRANCH ,A.SFA_CR_SVR_OPEID ,A.SFA_CR_SVR_BRANCH ,A.PHYS_DEST_IND ,A.CHG_DEST_IND ,A.DSB_DEST_IND ,A.CONTACT_PREDISB ,A.CONTACT_DISB ,A.CONTACT_POSTDISB ,A.SFA_CR_VERSION ,A.SFA_CR_PLUS_MPN ,A.CL_ACCEPT_CHNG ,A.SFA_CR_STAF_MPN ,A.PNOTE_DELIVER_DFLT ,A.LN_HOLD_REL_DFLT ,A.LN_RET_METH_CD ,A.SFA_FILE_PATH FROM PS_SFA_CRC_DEST A WHERE A.EFFDT = ( SELECT MAX(X.EFFDT) FROM PS_SFA_CRC_DEST X WHERE X.INSTITUTION = A.INSTITUTION AND X.LOAN_PROGRAM = A.LOAN_PROGRAM AND X.LN_DEST_NBR = A.LN_DEST_NBR AND X.EFFDT <= %CurrentDateIn ) AND A.EFF_STATUS = 'A'

  • Related Language Record: SFACRCDESTVWLNG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution

    Default Value: OPR_DEF_TBL_CS.INSTITUTION

    Prompt Table: INSTITUTION_TBL

    2 LOAN_PROGRAM Character(1) VARCHAR2(1) NOT NULL Loan Program
    A=Alternative
    D=Direct Lending
    F=FFELP
    H=Health Professions
    P=Perkins
    S=State
    U=University
    3 LN_DEST_NBR Number(3,0) SMALLINT NOT NULL Loan Destination Num

    Prompt Table: LN_DESTPROF_VW

    4 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    5 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description

    Default Value: SFA_CRC_DEST.DESCR

    6 INC_DEST_OVR Character(1) VARCHAR2(1) NOT NULL Incomplete Dest Override

    Y/N Table Edit

    Default Value: N

    7 SFA_CR_LNDR_OPEID Character(8) VARCHAR2(8) NOT NULL Lender OPEID

    Prompt Table: SFA_CRC_DESL_VW

    8 SFA_CR_LNDR_BRANCH Character(4) VARCHAR2(4) NOT NULL Lender Branch ID

    Prompt Table: SFA_CRC_DSL_VW2

    9 SFA_CR_GUAR_OPEID Character(8) VARCHAR2(8) NOT NULL Guarantor OPEID

    Prompt Table: SFA_CRC_DESG_VW

    10 SFA_CR_GUAR_BRANCH Character(4) VARCHAR2(4) NOT NULL Guarantor Branch ID
    11 SFA_CR_SVR_OPEID Character(8) VARCHAR2(8) NOT NULL Servicer OPEID

    Prompt Table: SFA_CRC_DESS_VW

    12 SFA_CR_SVR_BRANCH Character(4) VARCHAR2(4) NOT NULL Servicer Branch Code

    Prompt Table: SFA_CRC_DSS_VW2

    13 PHYS_DEST_IND Character(1) VARCHAR2(1) NOT NULL Physical Destination
    G=Guarantor
    L=Lender
    S=Servicer
    14 CHG_DEST_IND Character(1) VARCHAR2(1) NOT NULL Change Pre-Disb Destination In
    G=Guarantor
    L=Lender
    S=Servicer
    15 DSB_DEST_IND Character(1) VARCHAR2(1) NOT NULL Post Disb Destination Ind
    G=Guarantor
    L=Lender
    S=Servicer
    16 CONTACT_PREDISB Character(1) VARCHAR2(1) NOT NULL Pre-Disb Contact
    G=Guarantor
    L=Lender
    S=Servicer

    Default Value: S

    17 CONTACT_DISB Character(1) VARCHAR2(1) NOT NULL Disb Contact
    G=Guarantor
    L=Lender
    S=Servicer

    Default Value: S

    18 CONTACT_POSTDISB Character(1) VARCHAR2(1) NOT NULL Post Disb Contact
    G=Guarantor
    L=Lender
    S=Servicer

    Default Value: S

    19 SFA_CR_VERSION Character(4) VARCHAR2(4) NOT NULL Version
    C=Common Record Commonline
    20 SFA_CR_PLUS_MPN Character(1) VARCHAR2(1) NOT NULL PLUS MPN Processing Default (New or Serial)
    N=New MPN
    S=Serial MPN
    21 CL_ACCEPT_CHNG Character(1) VARCHAR2(1) NOT NULL Accepts CommonLine Change Recs

    Y/N Table Edit

    Default Value: Y

    22 SFA_CR_STAF_MPN Character(1) VARCHAR2(1) NOT NULL Stafford MPN Processing Default (New or Serial)
    N=New MPN
    S=Serial MPN
    23 PNOTE_DELIVER_DFLT Character(1) VARCHAR2(1) NOT NULL Destination attribute that indicates how the PNOTE will be sent to the borrower. For CL 4 processing.
    E=Email
    P=Paper
    W=Web

    Default Value: P

    24 LN_HOLD_REL_DFLT Character(1) VARCHAR2(1) NOT NULL Attribute which indicates whether the loan destination participates in a disbursement hold and release process.
    H=Hold Disbursement
    N=Not Supported
    R=Release Disbursement
    25 LN_RET_METH_CD Character(1) VARCHAR2(1) NOT NULL Funds Return Method Code
    E=Electronic Fund Transfer
    I=Borrower Check
    M=Master Check
    N=Netting

    Default Value: E

    26 SFA_FILE_PATH Character(250) VARCHAR2(250) NOT NULL File Path