ORG_CHKDTL_SRCH

(SQL View)
 Index Back

Organization Checklist Search

ORG_CHKDTL_SRCH is a detail search record for Organization Checklists.

SELECT DISTINCT D.OPRID , A.COMMON_ID , A.SEQ_3C , A.CHECKLIST_DTTM , A.INSTITUTION , A.ADMIN_FUNCTION , A.CHECKLIST_CD , B.OTH_NAME_SORT_SRCH , B.EXT_ORG_TYPE FROM PS_PERSON_CHECKLST A , PS_EXT_ORG_TBL B , 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.INQUIRY_USE_IND = 'Y'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
2 COMMON_ID Character(11) VARCHAR2(11) NOT NULL Common ID to store Personal ID / Ext Org ID value

Prompt Table: EXT_ORG_TBL

3 SEQ_3C Number(5,0) INTEGER NOT NULL Sequence Number
4 CHECKLIST_DTTM DateTime(26) TIMESTAMP Checklist Date Time
5 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution

Prompt Table: INSTITUTION_TBL

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

Prompt Table: ADM_FCN_ORG_VW

7 CHECKLIST_CD Character(6) VARCHAR2(6) NOT NULL Checklist Code
8 OTH_NAME_SORT_SRCH Character(50) VARCHAR2(50) NOT NULL Search Name
9 EXT_ORG_TYPE Character(4) VARCHAR2(4) NOT NULL Organization Type

Default Value: BUSN

Prompt Table: SCC_ORG_TYP_TBL