AV_INSTESRCHLNG(SQL View) |
Index Back |
---|---|
Advancement People Search ViewCommon view used when searching for/selecting a person for display/update. This view goes against the names table as well as the personal data table. The PeopleCode contained on this view is based upon the peoplecode in PEOPLE_SRCH. ----------------------------------------------------------------------------------------------------------------- Changed field from Name to Descr and made not a key - 12 Dec 2000 ----------------------------------------------------------------------------------------------------------------- Old View JFL 07/22/02: SELECT C.OPRID , C.INSTITUTION , A.DESCR , A.EXT_ORG_ID , A.EFFDT , A.EFF_STATUS , A.OTH_NAME_SORT_SRCH , A.EXT_ORG_TYPE , A.CITY , A.STATE , A.COUNTRY FROM PS_EXT_ORG_TBL A , PS_SCRTY_TBL_INST C WHERE C.ACCESS_CD = 'Y' ----------------------------------------------------------------------------------------------------------------- |
SELECT C.OPRID , C.INSTITUTION , A.EXT_ORG_ID , A.EFFDT , A.LANGUAGE_CD , A.DESCR FROM PS_EXT_ORG_LANG A , PS_SCRTY_TBL_INST C WHERE A.EFFDT = ( SELECT MAX(A1.EFFDT) FROM PS_EXT_ORG_LANG A1 WHERE A.EXT_ORG_ID = A1.EXT_ORG_ID AND A1.EFFDT <= %CurrentDateIn) AND C.ACCESS_CD = 'Y' |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). | |
2 | Character(5) | VARCHAR2(5) NOT NULL |
Institution
Default Value: AV_OPR_DEF_TBL.INSTITUTION Prompt Table: INSTITUTN_SCRTY |
|
3 | Character(11) | VARCHAR2(11) NOT NULL | External Org ID | |
4 | Date(10) | DATE | Effective Date | |
5 | Character(3) | VARCHAR2(3) NOT NULL | Language Code | |
6 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |