SCC_STG_CANEXAC

#	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_CAREER	Character(4)	VARCHAR2(4) NOT NULL	External Career GRAD=Graduate HS=High School LAW=Law MED=Medical UGRD=Undergraduate Default Value: EXT_ORG_TBL_ADM.EXT_CAREER
4	EXT_DATA_NBR	Number(3,0)	SMALLINT NOT NULL	External Data Nbr
5	SEQNUM	Number(3,0)	SMALLINT NOT NULL	Sequence Number Default Value: 1
6	EXT_ORG_ID	Character(11)	VARCHAR2(11) NOT NULL	External Org ID Default Value: EXT_ACAD_DATA.EXT_ORG_ID Prompt Table: EXT_ORG_TBL
7	CAN_ESIS_PREV_ACT	Character(2)	VARCHAR2(2) NOT NULL	SAC-R75-19990831
8	CAN_ESIS_PREV_CRED	Character(2)	VARCHAR2(2) NOT NULL	SAC-R75-19990831 01=General Equivalancy Diploma 02=Certificate 03=Diploma 04=Degree 05=Declaration of Achievement 06=Other College PostSecondary 07=Other College Non-PostSecond 08=Other Undergraduate Credential 09=Other Graduate Credential 96=Other Type of Credential 98=Not Applicable 99=Unknown
9	SCC_ROW_ADD_OPRID	Character(30)	VARCHAR2(30) NOT NULL	Created By
10	SCC_ROW_ADD_DTTM	DateTime(26)	TIMESTAMP	Created
11	SCC_ROW_UPD_OPRID	Character(30)	VARCHAR2(30) NOT NULL	Updated By
12	SCC_ROW_UPD_DTTM	DateTime(26)	TIMESTAMP	Last Update Date/Time