[Home] [Help] [Dependency Information]
Object Name: | PQH_FR_STAT_SITUATIONS_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | PQH.PQH_FR_STAT_SITUATIONS_V |
Subobject Name: | |
Status: | VALID |
A supplementary view used to simplify forms coding.
Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major
releases.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
STATUTORY_SITUATION_ID | NUMBER | (15) | Yes | Primary Key |
SITUATION_NAME | VARCHAR2 | (240) | Yes | Statutory Situation Name |
TYPE_OF_PS | VARCHAR2 | (30) | Yes | Type of Public Sector |
TYPE_OF_PS_NAME | VARCHAR2 | (4000) | Type of Public Sector - Name | |
SITUATION_TYPE | VARCHAR2 | (30) | Yes | Situation Type |
SITUATION_TYPE_NAME | VARCHAR2 | (4000) | Situation Type Name | |
SUB_TYPE | VARCHAR2 | (30) | Sub Type | |
SUB_TYPE_NAME | VARCHAR2 | (4000) | Sub Type Name | |
SOURCE | VARCHAR2 | (30) | Source | |
SOURCE_NAME | VARCHAR2 | (4000) | Source Name | |
LOCATION | VARCHAR2 | (30) | Location | |
LOCATION_NAME | VARCHAR2 | (4000) | Location Name | |
REASON | VARCHAR2 | (30) | Reason | |
REASON_NAME | VARCHAR2 | (4000) | Reason name | |
DATE_FROM | DATE | Active Date from | ||
DATE_TO | DATE | Active Date to | ||
REQUEST_TYPE | VARCHAR2 | (30) | Request Type | |
REQUEST_TYPE_NAME | VARCHAR2 | (4000) | Request type Name | |
EMPLOYEE_AGREEMENT_NEEDED | VARCHAR2 | (10) | Employee Agreement Needed Flag | |
MANAGER_AGREEMENT_NEEDED | VARCHAR2 | (10) | Manager Agreement Needed Flag | |
PRINT_ARRETTE | VARCHAR2 | (10) | Print Arrette Flag | |
RESERVE_POSITION | VARCHAR2 | (10) | Reserve Position | |
REMUNERATION_PAID | VARCHAR2 | (10) | Renumeration Paid | |
PAY_SHARE | NUMBER | (5) | Pay share | |
PAY_PERIODS | NUMBER | (15) | Pay Periods | |
FREQUENCY | VARCHAR2 | (30) | Frequency | |
FREQUENCY_NAME | VARCHAR2 | (4000) | Frequency Name | |
FIRST_PERIOD_MAX_DURATION | NUMBER | (15) | First Period Max 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) | Renewal 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 continuos duration | |
BUSINESS_GROUP_ID | NUMBER | (15) | Yes | Business Group Identifier |
RULESEXIST | VARCHAR2 | (4000) | Rule Exists Flag | |
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) | Default Flag (Y/N) | |
ALLOW_PROGRESSION_FLAG | VARCHAR2 | (10) | Allow Progression Flag (Y/N) | |
EXTEND_PROBATION_PERIOD_FLAG | VARCHAR2 | (10) | Extend Probation Period Flag (Y/N) | |
REMUNERATE_ASSIGN_STATUS_ID | NUMBER | (9) | Remuneration Assignment Status Identifier | |
REMUNERATE_ASSIGN_STATUS_NAME | VARCHAR2 | (4000) | Remuneration Assignment Status Name |
Cut, paste (and edit) the following text to query this object:
SELECT STATUTORY_SITUATION_ID
, SITUATION_NAME
, TYPE_OF_PS
, TYPE_OF_PS_NAME
, SITUATION_TYPE
, SITUATION_TYPE_NAME
, SUB_TYPE
, SUB_TYPE_NAME
, SOURCE
, SOURCE_NAME
, LOCATION
, LOCATION_NAME
, REASON
, REASON_NAME
, DATE_FROM
, DATE_TO
, REQUEST_TYPE
, REQUEST_TYPE_NAME
, EMPLOYEE_AGREEMENT_NEEDED
, MANAGER_AGREEMENT_NEEDED
, PRINT_ARRETTE
, RESERVE_POSITION
, REMUNERATION_PAID
, PAY_SHARE
, PAY_PERIODS
, FREQUENCY
, FREQUENCY_NAME
, 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
, BUSINESS_GROUP_ID
, RULESEXIST
, 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
, REMUNERATE_ASSIGN_STATUS_NAME
FROM APPS.PQH_FR_STAT_SITUATIONS_V;
|
|
|