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

TABLE: IGS.IGS_SS_PER_REL

Object Details
Object Name: IGS_SS_PER_REL
Object Type: TABLE
Owner: IGS
FND Design Data: TableIGS.IGS_SS_PER_REL
Subobject Name:
Status: VALID

***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

Storage Details
Tablespace: TablespaceAPPS_TS_ARCHIVE
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
IGS_SS_PER_REL_PK NORMAL UNIQUE TablespaceAPPS_TS_ARCHIVE ColumnSS_PER_REL_ID
Columns
Name Datatype Length Mandatory Comments
SS_PER_REL_ID NUMBER (15) Yes Online Employment Details Identifier ( SS_PER_REL_S )
PERSON_ID NUMBER (15) Yes person id
RELATIONSHIP_TYPE VARCHAR2 (30) Yes Relationship Type
SURNAME VARCHAR2 (150) Yes Surname
GIVEN_NAMES VARCHAR2 (150) Yes Given Names
MIDDLE_NAME VARCHAR2 (60)
Middle Name
PRE_NAME_ADJUNCT VARCHAR2 (30)
Prefix
TITLE VARCHAR2 (60)
Title
PREFERRED_GIVEN_NAME VARCHAR2 (240)
Preferred Given Name
BIRTH_DT DATE

Birth Date
SEX VARCHAR2 (30)
Sex (M/F/U )
EMAIL_ADDRESS VARCHAR2 (2000)
Email Address
DECEASED VARCHAR2 (1)
Deceased Indicator ( Y/N )
DECEASED_DATE DATE

Deceased Date
EMPLOYER VARCHAR2 (60)
Employer
DIVISION VARCHAR2 (60)
division
POSITION VARCHAR2 (60)
Position
COMMENTS VARCHAR2 (60)
Comments
START_DT DATE

Start Date
END_DT DATE

End Date
INSTITUTION_CD_1 VARCHAR2 (60)
Institution Code
CURRENT_INST_1 VARCHAR2 (1)
Current Institution Indicator (Y/N )
PROGRAM_TYPE_ATTEMPTED_1 VARCHAR2 (10)
Degree Attempted
PROGRAM_TYPE_EARNED_1 VARCHAR2 (60)
Degree Earned
COURSE_MAJOR_1 VARCHAR2 (60)
Program Code
COMMENTS_1 VARCHAR2 (240)
Comments
START_DATE_1 DATE

Start Date
END_DATE_1 DATE

End Date
INSTITUTION_CD_2 VARCHAR2 (60)
Institution Code
CURRENT_INST_2 VARCHAR2 (1)
Current Institution Indicator (Y/N )
PROGRAM_TYPE_ATTEMPTED_2 VARCHAR2 (10)
Degree Attempted
PROGRAM_TYPE_EARNED_2 VARCHAR2 (60)
Degree Earned
COURSE_MAJOR_2 VARCHAR2 (60)
Program Code
COMMENTS_2 VARCHAR2 (240)
Comments
START_DATE_2 DATE

Start Date
END_DATE_2 DATE

End Date
PM_SITE_USE_CODE VARCHAR2 (30)
Site use code
PM_START_DT DATE

Start date
PM_END_DT DATE

End date
PM_ADDR_LINE_1 VARCHAR2 (240)
Address Line 1
PM_ADDR_LINE_2 VARCHAR2 (240)
Address Line 2
PM_ADDR_LINE_3 VARCHAR2 (240)
Address Line 3
PM_ADDR_LINE_4 VARCHAR2 (240)
Address Line 4
PM_CITY VARCHAR2 (60)
City
PM_STATE VARCHAR2 (60)
State
PM_PROVINCE VARCHAR2 (60)
Province
PM_COUNTY VARCHAR2 (60)
County
PM_COUNTRY VARCHAR2 (60)
Country
PM_POSTAL_CODE VARCHAR2 (60)
Postal Code
PM_PHONE_1 VARCHAR2 (40)
Phone 1
PM_PHONE_LINE_TYPE_1 VARCHAR2 (30)
Phone line type
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
STATUS VARCHAR2 (30) Yes Inserted/Updated/Transferred
Query Text

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


SELECT SS_PER_REL_ID
,      PERSON_ID
,      RELATIONSHIP_TYPE
,      SURNAME
,      GIVEN_NAMES
,      MIDDLE_NAME
,      PRE_NAME_ADJUNCT
,      TITLE
,      PREFERRED_GIVEN_NAME
,      BIRTH_DT
,      SEX
,      EMAIL_ADDRESS
,      DECEASED
,      DECEASED_DATE
,      EMPLOYER
,      DIVISION
,      POSITION
,      COMMENTS
,      START_DT
,      END_DT
,      INSTITUTION_CD_1
,      CURRENT_INST_1
,      PROGRAM_TYPE_ATTEMPTED_1
,      PROGRAM_TYPE_EARNED_1
,      COURSE_MAJOR_1
,      COMMENTS_1
,      START_DATE_1
,      END_DATE_1
,      INSTITUTION_CD_2
,      CURRENT_INST_2
,      PROGRAM_TYPE_ATTEMPTED_2
,      PROGRAM_TYPE_EARNED_2
,      COURSE_MAJOR_2
,      COMMENTS_2
,      START_DATE_2
,      END_DATE_2
,      PM_SITE_USE_CODE
,      PM_START_DT
,      PM_END_DT
,      PM_ADDR_LINE_1
,      PM_ADDR_LINE_2
,      PM_ADDR_LINE_3
,      PM_ADDR_LINE_4
,      PM_CITY
,      PM_STATE
,      PM_PROVINCE
,      PM_COUNTY
,      PM_COUNTRY
,      PM_POSTAL_CODE
,      PM_PHONE_1
,      PM_PHONE_LINE_TYPE_1
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      STATUS
FROM IGS.IGS_SS_PER_REL;

Dependencies

[top of page]

IGS.IGS_SS_PER_REL does not reference any database object

IGS.IGS_SS_PER_REL is referenced by following:

SchemaAPPS
SynonymIGS_SS_PER_REL