SSR_APT_TIMETBL

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID Prompt Table: PEOPLE_SRCH
2	INSTITUTION	Character(5)	VARCHAR2(5) NOT NULL	Academic Institution Prompt Table: INSTITUTION_TBL
3	SSR_APT_INSTANCE	Number(3,0)	SMALLINT NOT NULL	Academic Progress Tracker Instance Number Default Value: 1
4	SSR_SEQ_NBR	Number(4,0)	SMALLINT NOT NULL	Sequence Number
5	SSR_NODE_ID	Number(4,0)	SMALLINT NOT NULL	Node ID Prompt Table: SSR_PROG_FORM_T
6	STRM	Character(4)	VARCHAR2(4) NOT NULL	Term Prompt Table: SSR_TERMCAT_VW
7	SESSION_CODE	Character(3)	VARCHAR2(3) NOT NULL	Session 1=Regular Academic Session 10W=10 Week 12W=Twelve Week 4W1=Four Week - First 4W2=Four Week - Second 4W3=Four Week - Third 4W4=Four Week - Fourth 6W1=Six Week - First 6W2=Six Week - Second 8W1=Eight Week - First 8W2=Eight Week - Second A11=Medical Period 1, 4 Weeks A12=Medical Period 1, 8 Weeks A13=Medical Pd 1, 12 Weeks A21=Medical Period 2, 4 Weeks A22=Medical Period 2, 8 Weeks A23=Medical Period 2, 12 Week FYR=Full Year MIN=Mini Session OEE=Open Entry/Open Exit SM1=Semester 1 SM2=Semester 2 Prompt Table: SESSION_TBL_VW
8	SSR_PERIOD_ID	Character(12)	VARCHAR2(12) NOT NULL	Academic Period ID Prompt Table: SSR_PLAN_PRD
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