TIME_SPANS

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID Default Value: OPR_DEF_TBL_FS.SETID Prompt Table: SP_SETID_NONVW
2	TIME_SPAN	Character(10)	VARCHAR2(10) NOT NULL	TimeSpan
3	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
4	START_YEAR_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Start Year Type A=Absolute Year R=Relative to Current Year Default Value: R
5	START_YEAR	Signed Number(5,0)	DECIMAL(4) NOT NULL	Start Year
6	START_PERIOD_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Start Period Type A=Absolute Period R=Relative to Current Period Default Value: R
7	START_PERIOD	Signed Number(4,0)	DECIMAL(3) NOT NULL	Start Period
8	END_YEAR_TYPE	Character(1)	VARCHAR2(1) NOT NULL	End Year Type A=Absolute Year R=Relative to Current Year Default Value: R
9	END_YEAR	Signed Number(5,0)	DECIMAL(4) NOT NULL	End Year
10	END_PERIOD_TYPE	Character(1)	VARCHAR2(1) NOT NULL	End Period Type A=Absolute Period R=Relative to Current Period Default Value: R
11	END_PERIOD	Signed Number(4,0)	DECIMAL(3) NOT NULL	End Period
12	INCLUDE_BAL_FRWD	Character(1)	VARCHAR2(1) NOT NULL	Include Balance Forward Y/N Table Edit Default Value: N
13	INCLUDE_CLOSE_PER	Character(1)	VARCHAR2(1) NOT NULL	Include Adjustment Periods N=No Adjustment Period S=Specify Adjustment Period Y=Adjustment Period 998 Default Value: N
14	CALENDAR_ID	Character(2)	VARCHAR2(2) NOT NULL	Calendar ID Prompt Table: CAL_DEFN_TBL
15	START_ADJPER_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Start Adjustment Period Type A=Absolute Period R=Relative to Current Period Default Value: R
16	START_ADJPER	Signed Number(4,0)	DECIMAL(3) NOT NULL	Start Adjustment Period
17	END_ADJPER_TYPE	Character(1)	VARCHAR2(1) NOT NULL	End Adjustment Period Type A=Absolute Period R=Relative to Current Period Default Value: R
18	END_ADJPER	Signed Number(4,0)	DECIMAL(3) NOT NULL	End Adjustment Period