SAD_OLA_ACHS_VW

(SQL View)
 Index Back

Admissions Sample Online App.

Sample Online Application record containing the last school attended information.

SELECT 0 , 0 , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , %DateNull , %DateNull , ' ' , ' ' , %DateNull , ' ' FROM PS_INSTALLATION_SA

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 SCC_TEMP_ID Number(16,0) DECIMAL(16) NOT NULL Temp Constituent ID
2 SEQ_NBR Number(15,0) DECIMAL(15) NOT NULL Sequence Number
3 EXT_ORG_ID Character(11) VARCHAR2(11) NOT NULL External Org ID

Prompt Table: SAD_OLA_SCHL_VW

4 SAD_SCHOOL_NAME Character(50) VARCHAR2(50) NOT NULL School Name
5 SAD_SCHOOL_ADDRESS Character(100) VARCHAR2(100) NOT NULL School Address
6 SAD_SCHOOL_CITY Character(50) VARCHAR2(50) NOT NULL School City
7 SAD_SCHOOL_STATE Character(6) VARCHAR2(6) NOT NULL School State

Prompt Table: STATE_TBL

8 SAD_SCHOOL_COUNTRY Character(3) VARCHAR2(3) NOT NULL School Country

Prompt Table: COUNTRY_TBL

9 SAD_SCHOOL_POSTAL Character(10) VARCHAR2(10) NOT NULL School Postal
10 SAD_SCHOOL_CEEB Character(6) VARCHAR2(6) NOT NULL School CEEB Code
11 SAD_SCHOOL_ACT Character(6) VARCHAR2(6) NOT NULL School ACT Code
12 SAD_OLA_NO_SCHOOL Character(1) VARCHAR2(1) NOT NULL Sample Online Application indicator that the applicants school was not found in the external org list.

Y/N Table Edit

13 FROM_DT Date(10) DATE From Date
14 TO_DT Date(10) DATE To Date
15 EXT_CAREER Character(4) VARCHAR2(4) NOT NULL External Career
GRAD=Graduate
HS=High School
LAW=Law
MED=Medical
UGRD=Undergraduate
16 DEGREE Character(8) VARCHAR2(8) NOT NULL Degree

Prompt Table: DEGREE_TBL

17 DEGREE_DT Date(10) DATE Admissions degree date.
18 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country