[Home] [Help] [Dependency Information]
Object Name: | HRI_MDS_WRKFC_ORGH_C01_CT |
---|---|
Object Type: | TABLE |
Owner: | HRI |
Subobject Name: | |
Status: | VALID |
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
HRI_MDS_WRKFC_ORGH_C01_CT_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX |
SUP_ORGANZTN_FK
TIME_MONTH_SNP_FK SUP_DIRECTS_ONLY_FLAG |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
SUP_ORGANZTN_FK | NUMBER | |||
SUP_DIRECTS_ONLY_FLAG | VARCHAR2 | (30) | ||
TIME_DAY_MNTH_START_FK | DATE | |||
TIME_DAY_MNTH_END_FK | DATE | |||
TIME_MONTH_SNP_FK | NUMBER | |||
JOB_FUNCTION_FK | VARCHAR2 | (240) | ||
JOB_FAMILY_FK | VARCHAR2 | (240) | ||
GEO_COUNTRY_FK | VARCHAR2 | (40) | ||
PRFM_PERFBAND_FK | NUMBER | |||
POW_POWBAND_FK | NUMBER | |||
PTYP_WRKTYP_FK | VARCHAR2 | (40) | ||
CUR_CURRENCY_FK | VARCHAR2 | (40) | ||
HEADCOUNT_START | NUMBER | |||
HEADCOUNT_END | NUMBER | |||
HEADCOUNT_HIRE | NUMBER | |||
HEADCOUNT_TERM | NUMBER | |||
HEADCOUNT_SEP_VOL | NUMBER | |||
HEADCOUNT_SEP_INVOL | NUMBER | |||
FTE_START | NUMBER | |||
FTE_END | NUMBER | |||
FTE_HIRE | NUMBER | |||
FTE_TERM | NUMBER | |||
FTE_SEP_VOL | NUMBER | |||
FTE_SEP_INVOL | NUMBER | |||
POW_DAYS_ON_END_DATE | NUMBER | |||
POW_MONTHS_ON_END_DATE | NUMBER | |||
ANL_SLRY_START | NUMBER | |||
ANL_SLRY_END | NUMBER | |||
CREATION_DATE | DATE | |||
CREATED_BY | NUMBER | (15) | ||
LAST_UPDATED_BY | NUMBER | (15) | ||
LAST_UPDATE_LOGIN | NUMBER | (15) | ||
LAST_UPDATE_DATE | DATE | |||
ADT_POW_BAND | NUMBER | |||
EMPLOYEE_IND | NUMBER | |||
CONTINGENT_IND | NUMBER | |||
HEADCOUNT_PRMTN | NUMBER | |||
FTE_PRMTN | NUMBER | |||
DAYS_SINCE_LAST_PRMTN | NUMBER | |||
MONTHS_SINCE_LAST_PRMTN | NUMBER | |||
COUNT_PASG_END | NUMBER | |||
COUNT_PASG_HIRE | NUMBER | |||
COUNT_PASG_TERM | NUMBER | |||
COUNT_PASG_SEP_VOL | NUMBER | |||
COUNT_PASG_SEP_INVOL | NUMBER | |||
COUNT_ASG_END | NUMBER | |||
COUNT_ASG_HIRE | NUMBER | |||
COUNT_ASG_TERM | NUMBER | |||
COUNT_ASG_SEP_VOL | NUMBER | |||
COUNT_ASG_SEP_INVOL | NUMBER | |||
COUNT_ASG_PRMTN | NUMBER |
Cut, paste (and edit) the following text to query this object:
SELECT SUP_ORGANZTN_FK
, SUP_DIRECTS_ONLY_FLAG
, TIME_DAY_MNTH_START_FK
, TIME_DAY_MNTH_END_FK
, TIME_MONTH_SNP_FK
, JOB_FUNCTION_FK
, JOB_FAMILY_FK
, GEO_COUNTRY_FK
, PRFM_PERFBAND_FK
, POW_POWBAND_FK
, PTYP_WRKTYP_FK
, CUR_CURRENCY_FK
, HEADCOUNT_START
, HEADCOUNT_END
, HEADCOUNT_HIRE
, HEADCOUNT_TERM
, HEADCOUNT_SEP_VOL
, HEADCOUNT_SEP_INVOL
, FTE_START
, FTE_END
, FTE_HIRE
, FTE_TERM
, FTE_SEP_VOL
, FTE_SEP_INVOL
, POW_DAYS_ON_END_DATE
, POW_MONTHS_ON_END_DATE
, ANL_SLRY_START
, ANL_SLRY_END
, CREATION_DATE
, CREATED_BY
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, LAST_UPDATE_DATE
, ADT_POW_BAND
, EMPLOYEE_IND
, CONTINGENT_IND
, HEADCOUNT_PRMTN
, FTE_PRMTN
, DAYS_SINCE_LAST_PRMTN
, MONTHS_SINCE_LAST_PRMTN
, COUNT_PASG_END
, COUNT_PASG_HIRE
, COUNT_PASG_TERM
, COUNT_PASG_SEP_VOL
, COUNT_PASG_SEP_INVOL
, COUNT_ASG_END
, COUNT_ASG_HIRE
, COUNT_ASG_TERM
, COUNT_ASG_SEP_VOL
, COUNT_ASG_SEP_INVOL
, COUNT_ASG_PRMTN
FROM HRI.HRI_MDS_WRKFC_ORGH_C01_CT;
HRI.HRI_MDS_WRKFC_ORGH_C01_CT does not reference any database object
HRI.HRI_MDS_WRKFC_ORGH_C01_CT is referenced by following:
|
|
|