ADB_ACT_LOG_TAO

(SQL Table)
Index Back

ADB Activity Log TAO

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT

Prompt Table: SP_BU_GL_NONVW

2 ADB Character(10) VARCHAR2(10) NOT NULL Average Daily Balances

Prompt Table: %EDITTABLE

3 ADB_TYPE Character(1) VARCHAR2(1) NOT NULL ADB Balance Type
0=Management Balances
1=Regulatory Balances
4 ADB_PERIOD_TYPE Character(1) VARCHAR2(1) NOT NULL Period Type
D=Date to Date
E=Year to Date
M=Month to Date
P=Regular Period
Q=Quarter to Date
R=Regular Date
5 FISCAL_YEAR Number(4,0) SMALLINT NOT NULL Fiscal Year
6 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.
7 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance