SCC_STG_ACADHST

#	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: EXT_ORGSCHL_VW
4	CHKLST_ITM_UPDT	Character(1)	VARCHAR2(1) NOT NULL	Checklist Item Update Y/N Table Edit Default Value: N
5	SAD_SCHOOL_NAME	Character(50)	VARCHAR2(50) NOT NULL	School Name
6	SAD_SCHOOL_ADDRESS	Character(100)	VARCHAR2(100) NOT NULL	School Address
7	SAD_SCHOOL_CITY	Character(50)	VARCHAR2(50) NOT NULL	School City
8	SAD_SCHOOL_STATE	Character(6)	VARCHAR2(6) NOT NULL	School State Prompt Table: STATE_TBL
9	SAD_SCHOOL_COUNTRY	Character(3)	VARCHAR2(3) NOT NULL	School Country Prompt Table: COUNTRY_TBL
10	SAD_SCHOOL_POSTAL	Character(10)	VARCHAR2(10) NOT NULL	School Postal
11	SAD_SCHOOL_CEEB	Character(6)	VARCHAR2(6) NOT NULL	School CEEB Code
12	SAD_SCHOOL_ACT	Character(6)	VARCHAR2(6) NOT NULL	School ACT Code
13	SAD_HOME_SCHL_FLAG	Character(1)	VARCHAR2(1) NOT NULL	SOLA indicator that student was home schooled. Y/N Table Edit Default Value: N
14	SAD_LAST_SCHL_FLAG	Character(1)	VARCHAR2(1) NOT NULL	SOLA indicator that this is the last school attended. Y/N Table Edit Default Value: N
15	INSTITUTION	Character(5)	VARCHAR2(5) NOT NULL	Academic Institution
16	SCC_ROW_ADD_OPRID	Character(30)	VARCHAR2(30) NOT NULL	Created By
17	SCC_ROW_ADD_DTTM	DateTime(26)	TIMESTAMP	Created
18	SCC_ROW_UPD_OPRID	Character(30)	VARCHAR2(30) NOT NULL	Updated By
19	SCC_ROW_UPD_DTTM	DateTime(26)	TIMESTAMP	Last Update Date/Time