SF_PRFL_LNG_VW

(SQL View)
 Index Back

SF Account Profile View


SELECT A.COMMON_ID , A.SA_ID_TYPE , A.TENDER_CATEGORY , A.SF_PROFILE_NBR , B.LANGUAGE_CD , B.DESCR , B.DESCRSHORT FROM PS_SF_ACCT_PROFILE A , PS_SF_ACCT_PFL_LNG B WHERE A.COMMON_ID = B.COMMON_ID AND A.SA_ID_TYPE = B.SA_ID_TYPE AND A.SF_PROFILE_NBR = B.SF_PROFILE_NBR

  • Related Language Record for SF_ACCT_PRFL_VW

    • # 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 SA_ID_TYPE Character(1) VARCHAR2(1) NOT NULL ID Type
    O=Organization
    P=Person
    3 TENDER_CATEGORY Character(3) VARCHAR2(3) NOT NULL Tender Category
    CC=Credit Card
    CCI=Credit Card In
    CCO=Credit Card Out
    CK=Check
    CKI=Check In
    CKO=Check Out
    CS=Cash
    CSI=Cash In
    CSO=Cash Out
    DB=Debit Card
    DBI=Debit Card In
    DBO=Debit Card Out
    DD=Direct Deposit
    DDI=Direct Debit
    DDO=Direct Deposit
    EC=Electronic Check
    TP=Third Party Check
    TPI=Third Party Check In
    WIR=Wire Transfer

    Prompt Table: TENDER_XLAT_VW

    4 SF_PROFILE_NBR Number(2,0) SMALLINT NOT NULL Account Profile
    5 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    6 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    7 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description