[Home] [Help] [Dependency Information]
Object Name: | PQH_FR_STAT_SITUATIONS# |
---|---|
Object Type: | VIEW |
Owner: | HR |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
STATUTORY_SITUATION_ID | NUMBER | (15) | Yes | |
BUSINESS_GROUP_ID | NUMBER | (15) | Yes | |
SITUATION_NAME | VARCHAR2 | (240) | Yes | |
TYPE_OF_PS | VARCHAR2 | (30) | Yes | |
SITUATION_TYPE | VARCHAR2 | (30) | Yes | |
SUB_TYPE | VARCHAR2 | (30) | ||
SOURCE | VARCHAR2 | (30) | ||
LOCATION | VARCHAR2 | (30) | ||
REASON | VARCHAR2 | (30) | ||
DATE_FROM | DATE | |||
DATE_TO | DATE | |||
REQUEST_TYPE | VARCHAR2 | (30) | ||
EMPLOYEE_AGREEMENT_NEEDED | VARCHAR2 | (10) | ||
MANAGER_AGREEMENT_NEEDED | VARCHAR2 | (10) | ||
PRINT_ARRETTE | VARCHAR2 | (10) | ||
RESERVE_POSITION | VARCHAR2 | (10) | ||
REMUNERATION_PAID | VARCHAR2 | (10) | ||
PAY_SHARE | NUMBER | (5) | ||
PAY_PERIODS | NUMBER | (15) | ||
FREQUENCY | VARCHAR2 | (30) | ||
FIRST_PERIOD_MAX_DURATION | NUMBER | (15) | ||
MIN_DURATION_PER_REQUEST | NUMBER | (15) | ||
MAX_DURATION_PER_REQUEST | NUMBER | (15) | ||
MAX_DURATION_WHOLE_CAREER | NUMBER | (15) | ||
RENEWABLE_ALLOWED | VARCHAR2 | (10) | ||
MAX_NO_OF_RENEWALS | NUMBER | (15) | ||
MAX_DURATION_PER_RENEWAL | NUMBER | (15) | ||
MAX_TOT_CONTINUOUS_DURATION | NUMBER | (15) | ||
CREATED_BY | NUMBER | (15) | Yes | |
CREATION_DATE | DATE | Yes | ||
LAST_UPDATE_DATE | DATE | |||
LAST_UPDATED_BY | NUMBER | (15) | ||
LAST_UPDATE_LOGIN | NUMBER | (15) | ||
OBJECT_VERSION_NUMBER | NUMBER | (9) | ||
DEFAULT_FLAG | VARCHAR2 | (10) | ||
ALLOW_PROGRESSION_FLAG | VARCHAR2 | (10) | ||
EXTEND_PROBATION_PERIOD_FLAG | VARCHAR2 | (10) | ||
REMUNERATE_ASSIGN_STATUS_ID | NUMBER | (9) |
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#;
|
|
|