| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 SETID1 |
Character(5) |
VARCHAR2(5) NOT NULL |
SetID Value
Default Value: OPR_DEF_TBL_FS.SETID
Prompt Table:
SP_SETID_NONVW
|
| 2 |
LEDGER_GROUP |
Character(10) |
VARCHAR2(10) NOT NULL |
Ledger Group
|
| 3 |
EFFDT |
Date(10) |
DATE NOT NULL |
Effective Date
|
| 4 |
SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
SetID
Prompt Table:
SP_SETID_NONVW
|
| 5 |
RANGE_FROM |
Character(30) |
VARCHAR2(30) NOT NULL |
Lower boundary for detail value that contains a range of values
Prompt Table:
%EDITTABLE
|
| 6 |
RANGE_TO |
Character(30) |
VARCHAR2(30) NOT NULL |
Upper boundary for detail value that contains a range of values
Prompt Table:
%EDITTABLE
|
| 7 |
CNTRL_OPTN |
Character(1) |
VARCHAR2(1) NOT NULL |
Commitment Control Option
0=Control
1=Tracking w/ Budget
2=Track w/o Budget
3=Default from Higher Level
4=Control Initial Document
Default Value: KK_BUDGET_TYPE.CNTRL_OPTN
|
| 8 |
BUDGET_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Budget Status
0=Open
1=Closed
2=Hold
3=Default
Default Value: 0
|
| 9 |
DFLT_TOLR |
Character(1) |
VARCHAR2(1) NOT NULL |
Default Tolerance
Y/N Table Edit
Default Value: Y
|
| 10 |
TOLERANCE |
Signed Number(13,8) |
DECIMAL(11,8) NOT NULL |
Tolerance Percent
|
| 11 |
KK_DERIVE_DATES |
Character(1) |
VARCHAR2(1) NOT NULL |
Derive Cumulative Date Range
0=Derive Yes
1=Derive No
2=Default
Default Value: 2
|
| 12 |
KK_CUM_CAL_ID |
Character(2) |
VARCHAR2(2) NOT NULL |
Cumulative Calendar
Prompt Table:
CAL_BP_VW
|
| 13 |
KK_FS_REQUIRED |
Character(1) |
VARCHAR2(1) NOT NULL |
Funding Source Required
Y/N Table Edit
Default Value: N
|
| 14 |
BEGIN_DT |
Date(10) |
DATE |
Begin Date
|
| 15 |
END_DT |
Date(10) |
DATE |
End Date
|
| 16 |
ENTRY_EVENT |
Character(10) |
VARCHAR2(10) NOT NULL |
Entry Event
Prompt Table:
KK_EE_CODES_VW
|
| 17 |
KK_STATUS_LN |
Character(1) |
VARCHAR2(1) NOT NULL |
Line Status
E=Error
N=Not Validated
V=Valid
Default Value: N
|
| 18 |
MESSAGE_SET_NBR |
Number(5,0) |
INTEGER NOT NULL |
Message Set Number. This field refers to the Message Set Number in the Message Catalog.
|
| 19 |
MESSAGE_NBR |
Number(5,0) |
INTEGER NOT NULL |
Message Number. This field refers to the Message Number in the Message Catalog.
|