KB_ALOG_STG

(SQL Table)
Index Back

Activity Log Deleted Entries

Activity Log Deleted Entries

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 KK_TRAN_ID Character(10) VARCHAR2(10) NOT NULL Commitment Control Foreign Key for Transaction Identification.
2 KK_TRAN_DT Date(10) DATE NOT NULL Commitment Control Transaction Original processing date. Primary key with KK_TRAN_ID.
3 KK_TRAN_LN Number(9,0) DECIMAL(9) NOT NULL Commitment Control Transaction Line number.
4 REFERENCED_BUDGET Character(1) VARCHAR2(1) NOT NULL Referenced Budget

Y/N Table Edit

Default Value: N

5 BALANCING_LINE Character(1) VARCHAR2(1) NOT NULL Balancing Line

Y/N Table Edit

Default Value: N

6 LEDGER_GROUP Character(10) VARCHAR2(10) NOT NULL Ledger Group
7 LEDGER Character(10) VARCHAR2(10) NOT NULL Ledger
8 FISCAL_YEAR Number(4,0) SMALLINT NOT NULL Fiscal Year
9 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.
10 SEQNBR Number(5,0) INTEGER NOT NULL Sequence Number
11 RVRSL_FLG Character(1) VARCHAR2(1) NOT NULL Commitment Control Reversal Flag
12 CLOSED_VALUE Character(1) VARCHAR2(1) NOT NULL Closed Status field value

Y/N Table Edit

13 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
14 DTTM_STAMP_SEC 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.