ACAD_SUBPLN_TBL

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	INSTITUTION	Character(5)	VARCHAR2(5) NOT NULL	Institution field to store institution information in campus solution system.
2	ACAD_PLAN	Character(10)	VARCHAR2(10) NOT NULL	Academic Plan field coming from campus solution system
3	ACAD_SUB_PLAN	Character(10)	VARCHAR2(10) NOT NULL	Academic sub plan, a field together with program, plan, and sub plan to store student program information.
4	EFFDT	Date(10)	DATE NOT NULL	Effective Date Default Value: %date
5	EFF_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Effective Status A=Active I=Inactive Default Value: A
6	ACAD_SUBPLAN_TYPE	Character(3)	VARCHAR2(3) NOT NULL	Academic Subplan Type
7	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
8	DESCRSHORT	Character(10)	VARCHAR2(10) NOT NULL	Short Description Default Value: ACAD_SUBPLN_TBL.DESCR
9	SUBPLN_REQTRM_DFLT	Character(1)	VARCHAR2(1) NOT NULL	Subplan Required Term Default Default Value: ACAD_PLAN_TBL.PLN_REQTRM_DFLT
10	DIPLOMA_DESCR	Character(100)	VARCHAR2(100) NOT NULL	This field stores the Diploma Description.
11	DIPLOMA_PRINT_FL	Character(1)	VARCHAR2(1) NOT NULL	Print on Diploma Y/N Table Edit Default Value: Y
12	DIPLOMA_INDENT	Number(2,0)	SMALLINT NOT NULL	This field is used to indicate number of characters to indent
13	TRNSCR_DESCR	Character(100)	VARCHAR2(100) NOT NULL	This field is used to store the Transcript Description.
14	TRNSCR_PRINT_FL	Character(1)	VARCHAR2(1) NOT NULL	Print on Transcipt value. Y/N Table Edit Default Value: Y
15	TRNSCR_INDENT	Number(2,0)	SMALLINT NOT NULL	Number of Characters Indent on Transcription
16	FIRST_TERM_VALID	Character(4)	VARCHAR2(4) NOT NULL	This field is used to indicate first valid term.
17	CIP_CODE	Character(13)	VARCHAR2(13) NOT NULL	CIP code
18	HEGIS_CODE	Character(8)	VARCHAR2(8) NOT NULL	This field is used for mentioning HEGIS code
19	TRANSCRIPT_LEVEL	Character(2)	VARCHAR2(2) NOT NULL	Transcript level Default Value: 20
20	EVALUATE_SUBPLAN	Character(1)	VARCHAR2(1) NOT NULL	Evalute Subplan Before Plan? Y/N Table Edit
21	SSR_LAST_PRS_DT	Date(10)	DATE	Field used to store the Last Prospect Date values.
22	SSR_LAST_ADM_TERM	Character(4)	VARCHAR2(4) NOT NULL	This field stores the Last Admitted Term.
23	ROW_ADDED_DTTM	DateTime(26)	TIMESTAMP	This is a datetime field for record creation.
24	ROW_ADDED_OPRID	Character(30)	VARCHAR2(30) NOT NULL	ID of user who added the row.
25	ROW_LASTMANT_DTTM	DateTime(26)	TIMESTAMP	The date and time that the row was last updated.
26	ROW_LASTMANT_OPRID	Character(30)	VARCHAR2(30) NOT NULL	ID of user who last modified the row.
27	SYNCID	Number(10,0)	DECIMAL(10) NOT NULL	The Synchronization ID field stores a value generated by the sync processor. The value is used to identify the type of object that the sync processor is about to handle.
28	SYNCDTTM	DateTime(26)	TIMESTAMP	Synchronization Last Update Date Time