KK_CLOSE_PR_LOG(SQL Table) |
Index Back |
|---|---|
Year End Closing Status Table |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  LEDGER_GROUP |
Character(10) | VARCHAR2(10) NOT NULL | Ledger Group |
| 2 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 3 | SETID |
Character(5) | VARCHAR2(5) NOT NULL |
SetID
Prompt Table: SP_SETID_NONVW |
| 4 | CLOSING_RULE_SET |
Character(20) | VARCHAR2(20) NOT NULL | Commitment Control Closing Rule Set |
| 5 | 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 |
| 6 | EFFDT | Date(10) | DATE | Effective Date |
| 7 | AS_OF_DATE |
Date(10) | DATE | As of Date |
| 8 | PROCESS_INSTANCE |
Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 9 | REQUEST_NBR |
Number(4,0) | SMALLINT NOT NULL | Request Number |
| 10 | OPRID | Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 11 | RUN_CNTL_ID | Character(30) | VARCHAR2(30) NOT NULL | Run Control ID |
| 12 | DTTM_STAMP | DateTime(26) | TIMESTAMP | Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts. |
| 13 | UNDO_PREV_PROCESS | Character(1) | VARCHAR2(1) NOT NULL | Undo Previous Process |
| 14 | CALC_LOG_OPTION | Character(1) | VARCHAR2(1) NOT NULL |
Create Calculations Log
C=Create Calc Log and Output N=No Calc Log - Create Output O=Create Calc Log - No Output Default Value: N |
| 15 | JOURNAL_ID_FROM | Character(10) | VARCHAR2(10) NOT NULL | Range From Journal ID |
| 16 | JOURNAL_ID_TO | Character(10) | VARCHAR2(10) NOT NULL | Range to Journal ID |
| 17 | JOURNAL_DATE | Date(10) | DATE | Specifies the date the journal was created. |