ORG_CHKLST_SRCH

(SQL View)
 Index Back

Organization Checklist Search

ORG_CHKLST_SRCH is a search record for ORG_CHECKLIST.

SELECT DISTINCT A.COMMON_ID , A.SEQ_3C , A.CHECKLIST_DTTM , A.ADMIN_FUNCTION , A.CHECKLIST_CD , B.DESCR , B.OTH_NAME_SORT_SRCH , B.EXT_ORG_TYPE FROM PS_EXT_ORG_TBL B , PS_PERSON_CHECKLST A , PS_CS_CHKLST_3CGRP C , PS_OPR_GRP_3C_TBL D WHERE A.COMMON_ID = B.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: ORG_CHKLST_LANG

    • # 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 CHECKLIST_DTTM DateTime(26) TIMESTAMP Checklist Date Time

    Default Value: %date

    4 ADMIN_FUNCTION Character(4) VARCHAR2(4) NOT NULL Administrative Function

    Prompt Table: ADM_FCN_ORG_VW

    5 CHECKLIST_CD Character(6) VARCHAR2(6) NOT NULL Checklist Code

    Prompt Table: CS_CHKLST_VW

    6 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    7 OTH_NAME_SORT_SRCH Character(50) VARCHAR2(50) NOT NULL Search Name
    8 EXT_ORG_TYPE Character(4) VARCHAR2(4) NOT NULL Organization Type

    Default Value: BUSN

    Prompt Table: SCC_ORG_TYP_TBL