ORG_ADM_CUR_VW

(SQL View)
 Index Back

External Org Admissions View

View of the EXT_ORG_TBL for Admissions as of the current date.

SELECT A.EXT_ORG_ID , A.EFFDT , A.EFF_STATUS , A.SCHOOL_CODE , A.LS_SCHOOL_TYPE , A.FICE_CD , A.ATP_CD , A.OFFERS_COURSES , A.ACT_CD , A.IPEDS_CD , A.SCHOOL_DISTRICT , A.ACCREDITED , A.TRANSCRIPT_XLATE , A.UNT_TYPE , A.EXT_TERM_TYPE , A.EXT_CAREER , A.SHARED_CATALOG , A.CATALOG_ORG , A.SCC_NCES_CD FROM PS_EXT_ORG_TBL_ADM A WHERE %EffdtCheck(EXT_ORG_TBL_ADM A1, A, %CurrentDateIn)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 EXT_ORG_ID Character(11) VARCHAR2(11) NOT NULL External Org ID
2 AS_OF_DATE Date(10) DATE As of Date
3 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
A=Active
I=Inactive
4 SCHOOL_CODE Character(10) VARCHAR2(10) NOT NULL School Code

Prompt Table: SCHOOL_TBL_VW

5 LS_SCHOOL_TYPE Character(3) VARCHAR2(3) NOT NULL School Type

Prompt Table: LS_SCHL_TYP_TBL

6 FICE_CD Character(6) VARCHAR2(6) NOT NULL FICE Code
7 ATP_CD Character(6) VARCHAR2(6) NOT NULL ATP Code
8 OFFERS_COURSES Character(1) VARCHAR2(1) NOT NULL Offers Courses

Y/N Table Edit

9 ACT_CD Character(6) VARCHAR2(6) NOT NULL ACT Code
10 IPEDS_CD Character(6) VARCHAR2(6) NOT NULL IPEDS Code
11 SCHOOL_DISTRICT Character(50) VARCHAR2(50) NOT NULL School District
12 ACCREDITED Character(1) VARCHAR2(1) NOT NULL Accredited School Indicator

Y/N Table Edit

13 TRANSCRIPT_XLATE Character(1) VARCHAR2(1) NOT NULL Transcript Translation Req

Y/N Table Edit

14 UNT_TYPE Character(3) VARCHAR2(3) NOT NULL Unit Type
ADU=Adult
CAR=Carnegie Units
CEU=Continuing Education Unit
NCR=No Credit
OTH=Non-Standard units
QTR=Quarter Units
SEM=Semester Units
UKN=Unknown
UNT=Units
VOC=Vocational
15 EXT_TERM_TYPE Character(4) VARCHAR2(4) NOT NULL External Term Type
1YR=Full Year
MINI=Miniterm
OTHR=Other
QTR=Quarter
QUIN=Quinmester
SEM=Semester
TRIM=Trimester
UNKN=Unknown
16 EXT_CAREER Character(4) VARCHAR2(4) NOT NULL External Career
GRAD=Graduate
HS=High School
LAW=Law
MED=Medical
UGRD=Undergraduate
17 SHARED_CATALOG Character(1) VARCHAR2(1) NOT NULL Shared Catalog

Y/N Table Edit

18 CATALOG_ORG Character(11) VARCHAR2(11) NOT NULL Catalog Organization

Prompt Table: CATALOG_ORG_VW

19 SCC_NCES_CD Character(12) VARCHAR2(12) NOT NULL National Center for Educatoin Statistics Code