ORG_CHKLST_LANG

(SQL View)
Index Back

ORG_CHKLST_LANG

Related Language view for ORG_CHKLST_SRCH

SELECT DISTINCT a.common_id , a.seq_3c , e.language_cd , e.descr FROM PS_EXT_ORG_TBL b , ps_person_checklst a , ps_cs_chklst_3cgrp c , ps_opr_grp_3c_tbl d , ps_ext_org_lang e WHERE a.common_id = b.ext_org_id AND a.common_id = e.ext_org_id AND a.institution = c.institution AND a.checklist_cd = c.checklist_cd AND c.institution = d.institution AND c.group_3c = d.group_3c AND d.entry_use_ind = 'Y'

  • Related Language Record for ORG_CHKLST_SRCH
  • # 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

    Prompt Table: EXT_ORG_SRCH

    2 SEQ_3C Number(5,0) INTEGER NOT NULL Sequence Number
    3 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    4 DESCR Character(30) VARCHAR2(30) NOT NULL Description