ADB_ACT_LOG (SQL Table)	Index Back
ADB Activity Log Table

ADB_ACT_LOG

(SQL Table)

ADB Activity Log Table

Related Language Record: ADB_ACT_LG_LANG

# 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_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

4 FISCAL_YEAR Number(4,0) SMALLINT NOT NULL Fiscal Year

5 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.

6 DESCR Character(30) VARCHAR2(30) NOT NULL Description

7 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance

8 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.

#	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_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
4	FISCAL_YEAR	Number(4,0)	SMALLINT NOT NULL	Fiscal Year
5	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.
6	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
7	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
8	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.