eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

DBA Data [Home] [Help] [Dependency Information]

TABLE: ABM.ABM_USERS

Object Details

Object Name:	ABM_USERS
Object Type:	TABLE
Owner:	ABM
Subobject Name:
Status:	VALID

An employee or associate of the organization.
Fairly static with respect to adds, dynamic with respect to updates, very heavy reads.
On window default display, sort by last name.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Primary Key: ABM_USERS_PK

I10_USERID

Indexes

Index	Type	Uniqueness	Tablespace	Column
ABM_USERS_PK	NORMAL	UNIQUE	APPS_TS_TX_IDX	I10_USERID

Foreign Keys

Table		Foreign Table	Foreign Key Column
ABM_USERS		ABM_SEC_PROFLS	ABM_USERS SYN_INST_I90_ID ABM_USERS SYN_INST_I97_NAME
ABM_USERS		ABM_SEC_PROFLS	ABM_USERS SYN_INTERF_I90_ID ABM_USERS SYN_INTERF_I97_NAME

Columns

Name	Datatype	Length	Mandatory	Comments
I10_USERID	VARCHAR2	(33)	Yes	ABM User Id.
LAST_NAME	VARCHAR2	(75)		User Last Name
FIRST_NAME	VARCHAR2	(75)		User First Name
PHONE_NUMBER	VARCHAR2	(60)		Contact Phone Number.
LOCATION	VARCHAR2	(90)		Location of the user
ACCT_AUTH_FLAG	VARCHAR2	(3)		Account Authorisation Flag
SYSADM_FLAG	VARCHAR2	(3)	Yes	Is the User a System Administrator or not.
DATE_FORMAT	VARCHAR2	(30)		Date Format
ACTIVA_PASSWORD	VARCHAR2	(30)		System password
DATABASE_USERID	VARCHAR2	(90)		Database User Id
DATABASE_PASSWORD	VARCHAR2	(90)		Database Password
LAST_PASSWORD_CHANGE_DATE	DATE			Date when the password was changed last.
LOGGED_ON_FLAG	VARCHAR2	(3)		Is the User logged on or not.
CONTEXT_EFF_DATE	DATE			Context Effective Date
I04_PROC_ID_CTR	NUMBER			Calculation Procedure ID counter
M25_MODEL_ID	VARCHAR2	(15)		Model Id
SYN_M20_PDS_ID_CHANGE	VARCHAR2	(30)		Changed PDS ID
SYN_M20_PDS_ID_VIEW	VARCHAR2	(30)		View PDS ID
I03_CURRENCY_ID	VARCHAR2	(15)		Currency Id
M24_MAPPING_RULE_SET_ID	VARCHAR2	(15)		Mapping Rule Set Id
SYN_I02_RE_HIER_ID	VARCHAR2	(30)		Department Hierarchy ID
SYN_I01_RE_HIER_ID	VARCHAR2	(30)		Department Hierarchy ID
SYN_I02_DRIVER_SET_ID	VARCHAR2	(30)		Activity Driver Set ID
SYN_I01_DRIVER_SET_ID	VARCHAR2	(30)		Activity Driver Set ID
MAINT_USER_ID	VARCHAR2	(11)		Legacy column. No longer used in ABM 11i.
MAINT_EFFECT_CODE	VARCHAR2	(1)		Legacy column. No longer used in ABM 11i.
MAINT_TIMESTAMP	DATE			Legacy column. No longer used in ABM 11i.
MESSAGE_LANGUAGE	VARCHAR2	(150)		Language ID of the message
SYN_INST_I90_ID	VARCHAR2	(15)		Instalation Attribute ID
SYN_INST_I97_NAME	VARCHAR2	(120)		Installation Attribute Name
SYN_INTERF_I90_ID	VARCHAR2	(15)		Interface Attribute ID
SYN_INTERF_I97_NAME	VARCHAR2	(120)		Interface Attribute Name
M18_BOR_TYPE_ID	VARCHAR2	(30)		Bill Type Id
O06_MASTER_LIST_SETS_ID	VARCHAR2	(15)		Master List Id
CURRENCY_FORMAT_MASK	VARCHAR2	(75)		Format Mask for the local currency
REAL_NUMBERS_FORMAT_MASK	VARCHAR2	(75)		Format Mask for Real Numbers
CREATION_DATE	DATE		Yes	Standard Who column
CREATED_BY	NUMBER	(15)	Yes	Standard Who column
LAST_UPDATE_DATE	DATE		Yes	Standard Who column
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard Who column
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard Who column
SYN_I02_RE_ACT_HIER_ID	VARCHAR2	(30)		Department Activity Hierarchy Attribute ID
SYN_I01_RE_ACT_HIER_ID	VARCHAR2	(30)		Department Activity Hierarchy Attribute Value
ABM_RESPONSIBILITY_NAME	VARCHAR2	(75)	Yes	ABM Responsibility Name
DESCRIPTION_TEXT	VARCHAR2	(750)		Description of the User
SYN_I02_RE_TAG_SET_ID	VARCHAR2	(30)		Department Attribute ID
SYN_I02_ACC_TAG_SET_ID	VARCHAR2	(30)		Account Attribute ID
SYN_I02_STA_TAG_SET_ID	VARCHAR2	(30)		Statistics Attribute ID
SYN_I02_DRV_TAG_SET_ID	VARCHAR2	(30)		Driver Attribute ID
SYN_I02_ACT_TAG_SET_ID	VARCHAR2	(30)		Activity Attribute ID
SYN_I02_MAT_TAG_SET_ID	VARCHAR2	(30)		Material Attribute ID
SYN_I02_CO_TAG_SET_ID	VARCHAR2	(30)		Cost Object Attribute ID

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT I10_USERID
,      LAST_NAME
,      FIRST_NAME
,      PHONE_NUMBER
,      LOCATION
,      ACCT_AUTH_FLAG
,      SYSADM_FLAG
,      DATE_FORMAT
,      ACTIVA_PASSWORD
,      DATABASE_USERID
,      DATABASE_PASSWORD
,      LAST_PASSWORD_CHANGE_DATE
,      LOGGED_ON_FLAG
,      CONTEXT_EFF_DATE
,      I04_PROC_ID_CTR
,      M25_MODEL_ID
,      SYN_M20_PDS_ID_CHANGE
,      SYN_M20_PDS_ID_VIEW
,      I03_CURRENCY_ID
,      M24_MAPPING_RULE_SET_ID
,      SYN_I02_RE_HIER_ID
,      SYN_I01_RE_HIER_ID
,      SYN_I02_DRIVER_SET_ID
,      SYN_I01_DRIVER_SET_ID
,      MAINT_USER_ID
,      MAINT_EFFECT_CODE
,      MAINT_TIMESTAMP
,      MESSAGE_LANGUAGE
,      SYN_INST_I90_ID
,      SYN_INST_I97_NAME
,      SYN_INTERF_I90_ID
,      SYN_INTERF_I97_NAME
,      M18_BOR_TYPE_ID
,      O06_MASTER_LIST_SETS_ID
,      CURRENCY_FORMAT_MASK
,      REAL_NUMBERS_FORMAT_MASK
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      SYN_I02_RE_ACT_HIER_ID
,      SYN_I01_RE_ACT_HIER_ID
,      ABM_RESPONSIBILITY_NAME
,      DESCRIPTION_TEXT
,      SYN_I02_RE_TAG_SET_ID
,      SYN_I02_ACC_TAG_SET_ID
,      SYN_I02_STA_TAG_SET_ID
,      SYN_I02_DRV_TAG_SET_ID
,      SYN_I02_ACT_TAG_SET_ID
,      SYN_I02_MAT_TAG_SET_ID
,      SYN_I02_CO_TAG_SET_ID
FROM ABM.ABM_USERS;

Dependencies

[top of page]

ABM.ABM_USERS does not reference any database object

ABM.ABM_USERS is not referenced by any database object