LOAN_CITIZEN_VW

(SQL View)
Index Back

Citizenship View for Loan Orig

LOAN_ORIG_SEC2

SELECT CITIZENSHIP_STATUS , DESCR , DESCRSHORT FROM PS_HCR_CTZN_STS_I WHERE COUNTRY = 'USA'

  • Related Language Record: LOANCITIZENVWLN
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 CITIZENSHIP_STATUS Character(1) VARCHAR2(1) NOT NULL Citizenship Status
    2 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    3 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description