INSTALLATION_KK(SQL Table) |
Index Back |
|---|---|
CC Installation OptionsCommitment Control Installation Options |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | KK_BP_LQD_OPTN | Character(1) | VARCHAR2(1) NOT NULL |
Commitment Control Budget Period Liquidation Installation Option
C=Current Document Budget Period P=Prior Document Budget Period Default Value: C |
| 2 | KK_FS_FLG_DATE | Character(1) | VARCHAR2(1) NOT NULL |
Active flag for additional Commitment Control Funding Source Date Field.
Y/N Table Edit Default Value: N |
| 3 | KK_FS_FLG_CHAR1 | Character(1) | VARCHAR2(1) NOT NULL |
Active flag for additional Commitment Control Funding Source Char1 Field.
Y/N Table Edit Default Value: N |
| 4 | KK_FS_FLG_CHAR2 | Character(1) | VARCHAR2(1) NOT NULL |
Active flag for additional Commitment Control Funding Source Char2 Field.
Y/N Table Edit Default Value: N |
| 5 | KK_FS_LBL_DATE | Character(15) | VARCHAR2(15) NOT NULL | Used to hold user-defined label for additional Commitment Control Funding Source Date Field. |
| 6 | KK_FS_LBL_CHAR1 | Character(15) | VARCHAR2(15) NOT NULL | Used to hold user-defined label for additional Commitment Control Funding Source Char1 Field. |
| 7 | KK_FS_LBL_CHAR2 | Character(15) | VARCHAR2(15) NOT NULL | Used to hold user-defined label for additional Commitment Control Funding Source Char2 Field. |
| 8 | RUN_ONLINE_MODE | Character(1) | VARCHAR2(1) NOT NULL |
Process run in online mode or not
Y/N Table Edit Default Value: N |
| 9 | SERVERNAME | Character(8) | VARCHAR2(8) NOT NULL |
Server Name
Prompt Table: PYCYCL_SERVERS |
| 10 | RUN_CNTL_PREFIX | Character(10) | VARCHAR2(10) NOT NULL | Run Control Prefix |
| 11 | LAST_PRCS_INSTANCE | Number(10,0) | DECIMAL(10) NOT NULL | Last Process Instance |
| 12 | MAX_WAIT_TIME | Number(9,0) | DECIMAL(9) NOT NULL |
Maximum Wait Time (Minutes)
Default Value: 5 |
| 13 | KK_CHECK_AP | Character(1) | VARCHAR2(1) NOT NULL | Payables |
| 14 | KK_CHECK_AR | Character(1) | VARCHAR2(1) NOT NULL | Receivables |
| 15 | KK_CHECK_BI | Character(1) | VARCHAR2(1) NOT NULL | Billing |
| 16 | KK_CHECK_CM | Character(1) | VARCHAR2(1) NOT NULL | Inventory |
| 17 | KK_CHECK_EX | Character(1) | VARCHAR2(1) NOT NULL | Expenses |
| 18 | KK_CHECK_GL | Character(1) | VARCHAR2(1) NOT NULL | General Ledger |
| 19 | KK_CHECK_KK | Character(1) | VARCHAR2(1) NOT NULL | Budget Journals |
| 20 | KK_CHECK_GM | Character(1) | VARCHAR2(1) NOT NULL | Grants |
| 21 | KK_CHECK_PC | Character(1) | VARCHAR2(1) NOT NULL | Project Costing |
| 22 | KK_CHECK_PO | Character(1) | VARCHAR2(1) NOT NULL | Purchasing |
| 23 | KK_CHECK_PRO | Character(1) | VARCHAR2(1) NOT NULL | Procurement Card |