| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
SetID
|
| 2 |
TIME_SET |
Character(10) |
VARCHAR2(10) NOT NULL |
A unique key identifier that represents a time horizon definition dataset.
|
| 3 |
SEQ_NUM |
Number(3,0) |
SMALLINT NOT NULL |
Sequence
|
| 4 |
START_PERIOD_DEF |
Character(2) |
VARCHAR2(2) NOT NULL |
The initial start date for a user defined time horizon to be utilized in conjunction with the system's
01=Today
02=Defined by Period above
03=Specific Period
04=Specific Date
Default Value: 01
|
| 5 |
START_DT |
Date(10) |
DATE |
Start Date
|
| 6 |
START_PRIOD_OFFSET |
Character(2) |
VARCHAR2(2) NOT NULL |
Describes a method in which a user can offset the desired start date for a succeeding time pe
01=Previous Week
02=Next Week
03=Previous Month
04=Next Month
05=Previous Quarter
06=Next Quarter
Prompt Table:
CAL_DEFN_TBL
|
| 7 |
PERIOD_TYPE_START |
Character(2) |
VARCHAR2(2) NOT NULL |
An internal work field utilized to keep track of the beginning forecast period in a time set during c
Prompt Table:
CAL_DEFN_TBL
|
| 8 |
PERIOD_TYPE_END |
Character(2) |
VARCHAR2(2) NOT NULL |
An internal work field utilized to keep track of the final forecast period in a time set during cash work
01=End of week
02=End of month
03=End of Fortnight
04=End of Quarter
05=End of Year
Prompt Table:
CAL_DEFN_TBL
|
| 9 |
END_PERIOD_DEF |
Character(2) |
VARCHAR2(2) NOT NULL |
Represents options for the user to determine the end time definition for a cash position worksheet tim
01=End of Next Cycle
02=Number of periods
03=End of Previous Cycle
04=End of Period
Default Value: 01
|
| 10 |
REPEAT_FREQ |
Character(2) |
VARCHAR2(2) NOT NULL |
Allows the user to indicate that repeating time periods are desired for a given time horizon definition.
Prompt Table:
CAL_DEFN_TBL
|
| 11 |
REPEAT_TYPE |
Character(2) |
VARCHAR2(2) NOT NULL |
"Represents the form of repeat rules
01=Use Period Definitions
02=Relative
Default Value: 01
|
| 12 |
REPEAT_RELATIVE |
Character(2) |
VARCHAR2(2) NOT NULL |
Represents the repeat rules for a given time horizon definition when a user wishes to set the start for a g
01=Days
02=Months
03=Years
|
| 13 |
REPEAT_NUMBER |
Number(3,0) |
SMALLINT NOT NULL |
Represents the number of repeating time periods desired for a given repeat cycle within a given time hor
|
| 14 |
REPEAT_TIMES |
Number(3,0) |
SMALLINT NOT NULL |
Represents the number of times a repeat cycle rule is to be executed when generating a given time horiz
|
| 15 |
DESCR50 |
Character(50) |
VARCHAR2(50) NOT NULL |
Description of length 50
|