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: PA.PA_ONLINE_EXP_SETTINGS

Object Details

Object Name:	PA_ONLINE_EXP_SETTINGS
Object Type:	TABLE
Owner:	PA
FND Design Data:	PA.PA_ONLINE_EXP_SETTINGS
Subobject Name:
Status:	VALID

PA_ONLINE_EXP_SETTINGS stores the user preferences for Self-Service Time users.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
PA_ONLINE_EXP_SETTINGS_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	PERSON_ID

Columns

Name	Datatype	Length	Mandatory	Comments
PERSON_ID	NUMBER	(9)	Yes	The person id of the user whose preferences are stored
OVERWRITE_HOT_KEYS	VARCHAR2	(1)	Yes	Obsolete
PA_HOT_KEYS_DISPLAYED	VARCHAR2	(1)	Yes	Obsolete
DEFAULT_WEEKS_BACK	NUMBER	(9)		Obsolete
LAST_UPDATE_DATE	DATE		Yes	Standard Who Column
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard Who Column
CREATION_DATE	DATE		Yes	Standard Who Column
CREATED_BY	NUMBER	(15)	Yes	Standard Who Column
LAST_UPDATE_LOGIN	NUMBER	(15)	Yes	Standard Who Column
DEFAULT_COMMENTS	VARCHAR2	(250)		The default free text comment for all Self Service Time timecards entered by this user
DEF_OVRRD_APPROVER_PERSON_ID	NUMBER			The default overriding approver for all SST timecards entered by this user
WORK_SUNDAY_FLAG	VARCHAR2	(1)		Flag that indicates whether the Sunday column will be displayed on the Enter Timecard matrix in Self Service Time
WORK_MONDAY_FLAG	VARCHAR2	(1)		Flag that indicates whether the Monday column will be displayed on the Enter Timecard matrix in Self Service Time
WORK_TUESDAY_FLAG	VARCHAR2	(1)		Flag that indicates whether the Tuesday column will be displayed on the Enter Timecard matrix in Self Service Time
WORK_WEDNESDAY_FLAG	VARCHAR2	(1)		Flag that indicates whether the Wednesday column will be displayed on the Enter Timecard matrix in Self Service Time
WORK_THURSDAY_FLAG	VARCHAR2	(1)		Flag that indicates whether the Thursday column will be displayed on the Enter Timecard matrix in Self Service Time
WORK_FRIDAY_FLAG	VARCHAR2	(1)		Flag that indicates whether the Friday column will be displayed on the Enter Timecard matrix in Self Service Time
WORK_SATURDAY_FLAG	VARCHAR2	(1)		Flag that indicates whether the Saturday column will be displayed on the Enter Timecard matrix in Self Service Time
TAB_MOVES_FLAG	VARCHAR2	(1)		Obsolete

Query Text

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


SELECT PERSON_ID
,      OVERWRITE_HOT_KEYS
,      PA_HOT_KEYS_DISPLAYED
,      DEFAULT_WEEKS_BACK
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      DEFAULT_COMMENTS
,      DEF_OVRRD_APPROVER_PERSON_ID
,      WORK_SUNDAY_FLAG
,      WORK_MONDAY_FLAG
,      WORK_TUESDAY_FLAG
,      WORK_WEDNESDAY_FLAG
,      WORK_THURSDAY_FLAG
,      WORK_FRIDAY_FLAG
,      WORK_SATURDAY_FLAG
,      TAB_MOVES_FLAG
FROM PA.PA_ONLINE_EXP_SETTINGS;

Dependencies

[top of page]

PA.PA_ONLINE_EXP_SETTINGS does not reference any database object

PA.PA_ONLINE_EXP_SETTINGS is referenced by following:

PA: PA_ONLINE_EXP_SETTINGS#