DBA Data[Home] [Help] [Dependency Information]

TABLE: HR.PER_JP_SCHOOL_LOOKUPS

Object Details
Object Name: PER_JP_SCHOOL_LOOKUPS
Object Type: TABLE
Owner: HR
FND Design Data: TablePER.PER_JP_SCHOOL_LOOKUPS
Subobject Name:
Status: VALID


PER_JP_SCHOOL_LOOKUPS holds information provided by external vendors
on Japanese educational institutions. This information is referenced
when validating entries into PER_ANALYSIS_CRITERIA. This table is
used only in JP-HRMS.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Primary Key: PER_JP_SCHOOL_LOOKUPS_PK
  1. ColumnSCHOOL_ID
Indexes
Index Type Uniqueness Tablespace Column
PER_JP_SCHOOL_LOOKUPS_PK NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnSCHOOL_ID
Columns
Name Datatype Length Mandatory Comments
SCHOOL_ID VARCHAR2 (11) Yes Primary Key (Characters)
SCHOOL_NAME VARCHAR2 (80)
School Name in Kanji Characters
SCHOOL_NAME_KANA VARCHAR2 (300)
School Name in Kana Characters
MAJOR VARCHAR2 (50)
Major in Kanji Characters
MAJOR_KANA VARCHAR2 (180)
Major in Kana Characters
CREATED_BY NUMBER (15) Yes Standard Who Column.
CREATION_DATE DATE
Yes Standard Who Column.
LAST_UPDATED_BY NUMBER (15) Yes Standard Who Column.
LAST_UPDATE_DATE DATE
Yes Standard Who Column.
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who Column.
Query Text

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


SELECT SCHOOL_ID
,      SCHOOL_NAME
,      SCHOOL_NAME_KANA
,      MAJOR
,      MAJOR_KANA
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
FROM HR.PER_JP_SCHOOL_LOOKUPS;

Dependencies

[top of page]

HR.PER_JP_SCHOOL_LOOKUPS does not reference any database object

HR.PER_JP_SCHOOL_LOOKUPS is referenced by following:

SchemaHR
ViewPER_JP_SCHOOL_LOOKUPS#