KK_CLOSE_SET(SQL Table) |
Index Back |
|---|---|
Closing Rule Sets |
| # | 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 | CLOSING_RULE_SET |
Character(20) | VARCHAR2(20) NOT NULL | Commitment Control Closing Rule Set |
| 3 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 4 | KK_CLOSE_PURPOSE | Character(1) | VARCHAR2(1) NOT NULL |
Added in FDM Release 8.8 to support JFMIP FM1.1 requirements to automaticly withdraw uncommitted and unobligated allotments, using the Budget Close process.
1=Process Budget Close 2=Reduce Budget without Closing Default Value: 1 |
| 5 | AS_OF_DATE | Date(10) | DATE NOT NULL |
As of Date
Default Value: %date |
| 6 | LEDGER_GROUP_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Ledger Group Type
A=Average Daily Balance B=Budget E=Commitment Control Expense R=Commitment Control Revenue S=Standard T=Translation |
| 7 | KK_CLOSE_BP_SW | Character(1) | VARCHAR2(1) NOT NULL |
Close Budget Period Yes/No flag for Budget Closing Set. A Yes means the Budget Closing process will be closing one or more Budget Periods for the Budgets, and if roll forward specified, the remaining balances will be moved to the specified Budget Period(s).
Y/N Table Edit Default Value: Y |
| 8 | BD_PERIOD_XFER_SET | Character(20) | VARCHAR2(20) NOT NULL |
Budget Period Set
Prompt Table: KK_BP_XFER_SET |
| 9 | KK_CLOSE_FY_SW | Character(1) | VARCHAR2(1) NOT NULL |
Close Fiscal Year Yes/No flag for Budget Closing Set. A Yes means the Budget Closing process will be closing a fiscal year for the Budgets, and if roll forward specified, the remaining balances will be moved to the next fiscal year.
Y/N Table Edit Default Value: N |
| 10 | FISCAL_YEAR | Number(4,0) | SMALLINT NOT NULL | Fiscal Year |
| 11 | DESCRLONG | Long Character | CLOB | Long Description |