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

TABLE: HR.PER_LETTER_TYPES

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


PER_LETTER_TYPES holds details of the types of letters that can be
sent to a person. CONCURRENT_PROGRAM_ID identifies the specific
program to run when this letter type is requested. User defined
programs should start with the name PERWP.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Primary Key: PER_LETTER_TYPES_PK
  1. ColumnLETTER_TYPE_ID
Unique Key: PER_LETTER_TYPES_UK2
  1. ColumnLETTER_TYPE_NAME
  2. ColumnBUSINESS_GROUP_ID
Indexes
Index Type Uniqueness Tablespace Column
PER_LETTER_TYPES_PK NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnLETTER_TYPE_ID
PER_LETTER_TYPES_UK2 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnLETTER_TYPE_NAME
ColumnBUSINESS_GROUP_ID
SYS_IL0000043357C00036$$ LOB UNIQUE TablespaceAPPS_TS_TX_DATA
PER_LETTER_TYPES_FK1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnBUSINESS_GROUP_ID
Foreign Keys
Table
Foreign Table Foreign Key Column
PER_LETTER_TYPES PER_LETTER_TYPES_FK1 TableHR_ALL_ORGANIZATION_UNITS PER_LETTER_TYPES BUSINESS_GROUP_ID
TablePER_LETTER_GEN_STATUSES PER_LETTER_GEN_STATUSES_FK3 PER_LETTER_TYPES PER_LETTER_GEN_STATUSES LETTER_TYPE_ID
TablePER_LETTER_REQUESTS PER_LETTER_REQUESTS_FK2 PER_LETTER_TYPES PER_LETTER_REQUESTS LETTER_TYPE_ID
Columns
Name Datatype Length Mandatory Comments
LETTER_TYPE_ID NUMBER (15) Yes System-generated primary key column.
BUSINESS_GROUP_ID NUMBER (15) Yes Foreign key to HR_ORGANIZATION_UNITS.
CONCURRENT_PROGRAM_ID NUMBER (15) Yes The concurrent program that is run when a letter request for this letter type is submitted to the concurrent manager.
LETTER_TYPE_NAME VARCHAR2 (30) Yes Letter type name, for example, Standard Offer Letter.
REQUEST_ID NUMBER (15)
Standard Who column.
PROGRAM_APPLICATION_ID NUMBER (15)
Standard Who column.
PROGRAM_ID NUMBER (15)
Standard Who column.
PROGRAM_UPDATE_DATE DATE

Standard Who column.
ATTRIBUTE_CATEGORY VARCHAR2 (30)
Descriptive flexfield structure defining column.
ATTRIBUTE1 VARCHAR2 (150)
Descriptive flexfield column.
ATTRIBUTE2 VARCHAR2 (150)
Descriptive flexfield column.
ATTRIBUTE3 VARCHAR2 (150)
Descriptive flexfield column.
ATTRIBUTE4 VARCHAR2 (150)
Descriptive flexfield column.
ATTRIBUTE5 VARCHAR2 (150)
Descriptive flexfield column.
ATTRIBUTE6 VARCHAR2 (150)
Descriptive flexfield column.
ATTRIBUTE7 VARCHAR2 (150)
Descriptive flexfield column.
ATTRIBUTE8 VARCHAR2 (150)
Descriptive flexfield column.
ATTRIBUTE9 VARCHAR2 (150)
Descriptive flexfield column.
ATTRIBUTE10 VARCHAR2 (150)
Descriptive flexfield column.
ATTRIBUTE11 VARCHAR2 (150)
Descriptive flexfield column.
ATTRIBUTE12 VARCHAR2 (150)
Descriptive flexfield column.
ATTRIBUTE13 VARCHAR2 (150)
Descriptive flexfield column.
ATTRIBUTE14 VARCHAR2 (150)
Descriptive flexfield column.
ATTRIBUTE15 VARCHAR2 (150)
Descriptive flexfield column.
ATTRIBUTE16 VARCHAR2 (150)
Descriptive flexfield column.
ATTRIBUTE17 VARCHAR2 (150)
Descriptive flexfield column.
ATTRIBUTE18 VARCHAR2 (150)
Descriptive flexfield column.
ATTRIBUTE19 VARCHAR2 (150)
Descriptive flexfield column.
ATTRIBUTE20 VARCHAR2 (150)
Descriptive flexfield column.
LAST_UPDATE_DATE DATE

Standard Who column.
LAST_UPDATED_BY NUMBER (15)
Standard Who column.
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who column.
CREATED_BY NUMBER (15)
Standard Who column.
CREATION_DATE DATE

Standard Who column.
GENERATION_STATUS_TYPE VARCHAR2 (30)
Type of status change used to generate letter request lines e.g. a training booking or applicant assignment.
COMMENTS CLOB (4000)
General remark.
Query Text

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


SELECT LETTER_TYPE_ID
,      BUSINESS_GROUP_ID
,      CONCURRENT_PROGRAM_ID
,      LETTER_TYPE_NAME
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      ATTRIBUTE16
,      ATTRIBUTE17
,      ATTRIBUTE18
,      ATTRIBUTE19
,      ATTRIBUTE20
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CREATED_BY
,      CREATION_DATE
,      GENERATION_STATUS_TYPE
,      COMMENTS
FROM HR.PER_LETTER_TYPES;

Dependencies

[top of page]

HR.PER_LETTER_TYPES does not reference any database object

HR.PER_LETTER_TYPES is referenced by following:

SchemaHR
ViewPER_LETTER_TYPES#