| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 PROCESS_INSTANCE |
Number(10,0) |
DECIMAL(10) NOT NULL |
Process Instance
|
| 2 |
START_YEAR_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Start Year Type
A=Absolute Year
R=Relative to Current Year
Default Value: R
|
| 3 |
START_YEAR |
Signed Number(5,0) |
DECIMAL(4) NOT NULL |
Start Year
|
| 4 |
START_PERIOD_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Start Period Type
A=Absolute Period
R=Relative to Current Period
Default Value: R
|
| 5 |
START_PERIOD |
Signed Number(4,0) |
DECIMAL(3) NOT NULL |
Start Period
|
| 6 |
END_YEAR_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
End Year Type
A=Absolute Year
R=Relative to Current Year
Default Value: R
|
| 7 |
END_YEAR |
Signed Number(5,0) |
DECIMAL(4) NOT NULL |
End Year
|
| 8 |
END_PERIOD_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
End Period Type
A=Absolute Period
R=Relative to Current Period
Default Value: R
|
| 9 |
END_PERIOD |
Signed Number(4,0) |
DECIMAL(3) NOT NULL |
End Period
|
| 10 |
INCLUDE_BAL_FRWD |
Character(1) |
VARCHAR2(1) NOT NULL |
Include Balance Forward
Default Value: N
|
| 11 |
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
|
| 12 |
CALENDAR_ID |
Character(2) |
VARCHAR2(2) NOT NULL |
Calendar ID
|
| 13 |
START_ADJPER_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Start Adjustment Period Type
A=Absolute Period
R=Relative to Current Period
Default Value: R
|
| 14 |
START_ADJPER |
Signed Number(4,0) |
DECIMAL(3) NOT NULL |
Start Adjustment Period
|
| 15 |
END_ADJPER_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
End Adjustment Period Type
A=Absolute Period
R=Relative to Current Period
Default Value: R
|
| 16 |
END_ADJPER |
Signed Number(4,0) |
DECIMAL(3) NOT NULL |
End Adjustment Period
|
| 17 |
SETID_CALENDAR |
Character(5) |
VARCHAR2(5) NOT NULL |
Calendar Setid
|
| 18 |
SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
SetID
|
| 19 |
NUMBER_OF_PERIODS |
Number(3,0) |
SMALLINT NOT NULL |
Periods in a Year
|
| 20 |
CALENDAR_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Type of Calendar
B=Budget Calendar
D=Detail Calendar
I=Summary Budget Period Calendar
P=Budget Period Calendar
S=Summary Calendar
T=Promo Mgmt Sales Calendar
|
| 21 |
DETAIL_CALENDAR |
Character(2) |
VARCHAR2(2) NOT NULL |
Detail Calendar
|
| 22 |
FISCAL_YEAR |
Number(4,0) |
SMALLINT NOT NULL |
Fiscal Year
|
| 23 |
ACCOUNTING_PERIOD |
Number(3,0) |
SMALLINT NOT NULL |
Identifies a time period to which you post transactions. Typically, an accounting period represents a month, but it can also represent a week, a day, or any user-defined interval. An accounting period has a beginning date and an ending date, and is defined in the calendar table.
|
| 24 |
FISCAL_YEAR_FROM |
Number(4,0) |
SMALLINT NOT NULL |
Fiscal Year
|
| 25 |
ACCOUNTING_PD_FROM |
Number(3,0) |
SMALLINT NOT NULL |
Range From Accounting Period
|
| 26 |
SQL_DYNAMIC_WHERE |
Character(254) |
VARCHAR2(254) NOT NULL |
|
| 27 |
BEGIN_DT |
Date(10) |
DATE |
Begin Date
|
| 28 |
END_DT |
Date(10) |
DATE |
End Date
|
| 29 |
DATE_FIELDNAME |
Character(18) |
VARCHAR2(18) NOT NULL |
"(Generic field that crosses multiple products; in Treasury
|