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: HR.PQH_FR_STAT_SITUATIONS

Object Details

Object Name:	PQH_FR_STAT_SITUATIONS
Object Type:	TABLE
Owner:	HR
FND Design Data:	PQH.PQH_FR_STAT_SITUATIONS
Subobject Name:
Status:	VALID

Stores details on Statutory Situations

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
PQH_FR_STAT_SITUATIONS_PK	NORMAL	UNIQUE	APPS_TS_TX_IDX	STATUTORY_SITUATION_ID

Columns

Name	Datatype	Length	Mandatory	Comments
STATUTORY_SITUATION_ID	NUMBER	(15)	Yes	Primary Key
BUSINESS_GROUP_ID	NUMBER	(15)	Yes	Business Group Identifier
SITUATION_NAME	VARCHAR2	(240)	Yes	Statutory Situation Name
TYPE_OF_PS	VARCHAR2	(30)	Yes	Type of Public Sector
SITUATION_TYPE	VARCHAR2	(30)	Yes	Type of situation
SUB_TYPE	VARCHAR2	(30)		Situation sub type based on the above situation type
SOURCE	VARCHAR2	(30)		Source
LOCATION	VARCHAR2	(30)		Civil Servant's Location
REASON	VARCHAR2	(30)		Situation Reason
DATE_FROM	DATE			Active From Date
DATE_TO	DATE			Active To Date
REQUEST_TYPE	VARCHAR2	(30)		Type of request made
EMPLOYEE_AGREEMENT_NEEDED	VARCHAR2	(10)		Employee agreement required flag
MANAGER_AGREEMENT_NEEDED	VARCHAR2	(10)		Manager agreement required flag
PRINT_ARRETTE	VARCHAR2	(10)		Decree to printed flag
RESERVE_POSITION	VARCHAR2	(10)		Position to be reserved for the period of situation
REMUNERATION_PAID	VARCHAR2	(10)		Renumeration to be paid flag
PAY_SHARE	NUMBER	(5)		Pay share
PAY_PERIODS	NUMBER	(15)		Number of pay periods
FREQUENCY	VARCHAR2	(30)		frequency
FIRST_PERIOD_MAX_DURATION	NUMBER	(15)		First period maximum duration
MIN_DURATION_PER_REQUEST	NUMBER	(15)		Minimum duration per request
MAX_DURATION_PER_REQUEST	NUMBER	(15)		Maximum duration per request
MAX_DURATION_WHOLE_CAREER	NUMBER	(15)		Maximum duration for whole career
RENEWABLE_ALLOWED	VARCHAR2	(10)		Renewable allowed flag
MAX_NO_OF_RENEWALS	NUMBER	(15)		Maximum number of renewals
MAX_DURATION_PER_RENEWAL	NUMBER	(15)		Maximum duration per renewal
MAX_TOT_CONTINUOUS_DURATION	NUMBER	(15)		Maximum total continous duration
CREATED_BY	NUMBER	(15)	Yes	Standard WHO Column
CREATION_DATE	DATE		Yes	Standard WHO Column
LAST_UPDATE_DATE	DATE			Standard WHO Column
LAST_UPDATED_BY	NUMBER	(15)		Standard WHO Column
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard WHO Column
OBJECT_VERSION_NUMBER	NUMBER	(9)		Object Version Number
DEFAULT_FLAG	VARCHAR2	(10)		Mark as Default (Y/ N)
ALLOW_PROGRESSION_FLAG	VARCHAR2	(10)		Allow Progression (Y/ N)
EXTEND_PROBATION_PERIOD_FLAG	VARCHAR2	(10)		Allow Extension of Probation Period (Y/ N)
REMUNERATE_ASSIGN_STATUS_ID	NUMBER	(9)		Remuneration Assignment Status Identifier

Query Text

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


SELECT STATUTORY_SITUATION_ID
,      BUSINESS_GROUP_ID
,      SITUATION_NAME
,      TYPE_OF_PS
,      SITUATION_TYPE
,      SUB_TYPE
,      SOURCE
,      LOCATION
,      REASON
,      DATE_FROM
,      DATE_TO
,      REQUEST_TYPE
,      EMPLOYEE_AGREEMENT_NEEDED
,      MANAGER_AGREEMENT_NEEDED
,      PRINT_ARRETTE
,      RESERVE_POSITION
,      REMUNERATION_PAID
,      PAY_SHARE
,      PAY_PERIODS
,      FREQUENCY
,      FIRST_PERIOD_MAX_DURATION
,      MIN_DURATION_PER_REQUEST
,      MAX_DURATION_PER_REQUEST
,      MAX_DURATION_WHOLE_CAREER
,      RENEWABLE_ALLOWED
,      MAX_NO_OF_RENEWALS
,      MAX_DURATION_PER_RENEWAL
,      MAX_TOT_CONTINUOUS_DURATION
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      OBJECT_VERSION_NUMBER
,      DEFAULT_FLAG
,      ALLOW_PROGRESSION_FLAG
,      EXTEND_PROBATION_PERIOD_FLAG
,      REMUNERATE_ASSIGN_STATUS_ID
FROM HR.PQH_FR_STAT_SITUATIONS;

Dependencies

[top of page]

HR.PQH_FR_STAT_SITUATIONS does not reference any database object

HR.PQH_FR_STAT_SITUATIONS is referenced by following:

APPS: PQH_FR_STAT_SITUATIONS; PQH_FR_STAT_SITUATIONS_WHO
PUBLIC: PQH_FR_STAT_SITUATIONS