eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

TABLE: HR.GHR_INTERFACE

Object Details

Object Name:	GHR_INTERFACE
Object Type:	TABLE
Owner:	HR
FND Design Data:	GHR.GHR_INTERFACE
Subobject Name:
Status:	VALID

This is a genreal purpose table for various interfaces with Federal HR
system. Development team will write various interfaces based on this
table to move data to HR database. Currently this table is being used
for Payroll interface to get data pertaining to SF-113A report.

Storage Details

Tablespace:	APPS_TS_INTERFACE
PCT Free:	10
PCT Used:

Primary Key: GHR_INTERFACE_PK

INTERFACE_ID

Indexes

Index	Type	Uniqueness	Tablespace	Column
GHR_INTERFACE_PK	NORMAL	UNIQUE	APPS_TS_INTERFACE	INTERFACE_ID
GHR_INTERFACE_N1	NORMAL	NONUNIQUE	APPS_TS_INTERFACE	INFORMATION1 INFORMATION4

Columns

Name	Datatype	Length	Mandatory	Comments
INTERFACE_ID	NUMBER	(15)	Yes	Primary key generated from sequence GHR_INTERFACES_S.
PROCESS_DATE	DATE		Yes	Interface process date.
SOURCE_NAME	VARCHAR2	(30)		Name of the interface source which created this record, e.g. PAYROLL.
DATE_FROM	DATE			The date on which the interface becomes effective.
DATE_TO	DATE			The date after which the interface is no longer effective.
INFORMATION1	VARCHAR2	(255)		Developer defined column based on SOURCE_NAME.
INFORMATION2	VARCHAR2	(255)		Developer defined column based on SOURCE_NAME.
INFORMATION3	VARCHAR2	(255)		Developer defined column based on SOURCE_NAME.
INFORMATION4	VARCHAR2	(255)		Developer defined column based on SOURCE_NAME.
INFORMATION5	VARCHAR2	(255)		Developer defined column based on SOURCE_NAME.
INFORMATION6	VARCHAR2	(255)		Developer defined column based on SOURCE_NAME.
INFORMATION7	VARCHAR2	(255)		Developer defined column based on SOURCE_NAME.
INFORMATION8	VARCHAR2	(255)		Developer defined column based on SOURCE_NAME.
INFORMATION9	VARCHAR2	(255)		Developer defined column based on SOURCE_NAME.
INFORMATION10	VARCHAR2	(255)		Developer defined column based on SOURCE_NAME.
INFORMATION11	VARCHAR2	(255)		Developer defined column based on SOURCE_NAME.
INFORMATION12	VARCHAR2	(255)		Developer defined column based on SOURCE_NAME.
INFORMATION13	VARCHAR2	(255)		Developer defined column based on SOURCE_NAME.
INFORMATION14	VARCHAR2	(255)		Developer defined column based on SOURCE_NAME.
INFORMATION15	VARCHAR2	(255)		Developer defined column based on SOURCE_NAME.
INFORMATION16	VARCHAR2	(255)		Developer defined column based on SOURCE_NAME.
INFORMATION17	VARCHAR2	(255)		Developer defined column based on SOURCE_NAME.
INFORMATION18	VARCHAR2	(255)		Developer defined column based on SOURCE_NAME.
INFORMATION19	VARCHAR2	(255)		Developer defined column based on SOURCE_NAME.
INFORMATION20	VARCHAR2	(255)		Developer defined column based on SOURCE_NAME.
INFORMATION21	VARCHAR2	(255)		Developer defined column based on SOURCE_NAME.
INFORMATION22	VARCHAR2	(255)		Developer defined column based on SOURCE_NAME.
INFORMATION23	VARCHAR2	(255)		Developer defined column based on SOURCE_NAME.
INFORMATION24	VARCHAR2	(255)		Developer defined column based on SOURCE_NAME.
INFORMATION25	VARCHAR2	(255)		Developer defined column based on SOURCE_NAME.
INFORMATION26	VARCHAR2	(255)		Developer defined column based on SOURCE_NAME.
INFORMATION27	VARCHAR2	(255)		Developer defined column based on SOURCE_NAME.
INFORMATION28	VARCHAR2	(255)		Developer defined column based on SOURCE_NAME.
INFORMATION29	VARCHAR2	(255)		Developer defined column based on SOURCE_NAME.
INFORMATION30	VARCHAR2	(255)		Developer defined column based on SOURCE_NAME.
INFORMATION31	VARCHAR2	(255)		Developer defined column based on SOURCE_NAME.
INFORMATION32	VARCHAR2	(255)		Developer defined column based on SOURCE_NAME.
INFORMATION33	VARCHAR2	(255)		Developer defined column based on SOURCE_NAME.
INFORMATION34	VARCHAR2	(255)		Developer defined column based on SOURCE_NAME.
INFORMATION35	VARCHAR2	(255)		Developer defined column based on SOURCE_NAME.
INFORMATION36	VARCHAR2	(255)		Developer defined column based on SOURCE_NAME.
INFORMATION37	VARCHAR2	(255)		Developer defined column based on SOURCE_NAME.
INFORMATION38	VARCHAR2	(255)		Developer defined column based on SOURCE_NAME.
INFORMATION39	VARCHAR2	(255)		Developer defined column based on SOURCE_NAME.
INFORMATION40	VARCHAR2	(255)		Developer defined column based on SOURCE_NAME.
INFORMATION41	VARCHAR2	(255)		Developer defined column based on SOURCE_NAME.
INFORMATION42	VARCHAR2	(255)		Developer defined column based on SOURCE_NAME.
INFORMATION43	VARCHAR2	(255)		Developer defined column based on SOURCE_NAME.
INFORMATION44	VARCHAR2	(255)		Developer defined column based on SOURCE_NAME.
INFORMATION45	VARCHAR2	(255)		Developer defined column based on SOURCE_NAME.
INFORMATION46	VARCHAR2	(255)		Developer defined column based on SOURCE_NAME.
INFORMATION47	VARCHAR2	(255)		Developer defined column based on SOURCE_NAME.
INFORMATION48	VARCHAR2	(255)		Developer defined column based on SOURCE_NAME.
INFORMATION49	VARCHAR2	(255)		Developer defined column based on SOURCE_NAME.
INFORMATION50	VARCHAR2	(255)		Developer defined column based on SOURCE_NAME.
INFORMATION51	VARCHAR2	(255)		Developer defined column based on SOURCE_NAME.
INFORMATION52	VARCHAR2	(255)		Developer defined column based on SOURCE_NAME.
INFORMATION53	VARCHAR2	(255)		Developer defined column based on SOURCE_NAME.
INFORMATION54	VARCHAR2	(255)		Developer defined column based on SOURCE_NAME.
INFORMATION55	VARCHAR2	(255)		Developer defined column based on SOURCE_NAME.
INFORMATION56	VARCHAR2	(255)		Developer defined column based on SOURCE_NAME.
INFORMATION57	VARCHAR2	(255)		Developer defined column based on SOURCE_NAME.
INFORMATION58	VARCHAR2	(255)		Developer defined column based on SOURCE_NAME.
INFORMATION59	VARCHAR2	(255)		Developer defined column based on SOURCE_NAME.
INFORMATION60	VARCHAR2	(255)		Developer defined column based on SOURCE_NAME.
INFORMATION61	VARCHAR2	(255)		Developer defined column based on SOURCE_NAME.
INFORMATION62	VARCHAR2	(255)		Developer defined column based on SOURCE_NAME.
INFORMATION63	VARCHAR2	(255)		Developer defined column based on SOURCE_NAME.
INFORMATION64	VARCHAR2	(255)		Developer defined column based on SOURCE_NAME.
INFORMATION65	VARCHAR2	(255)		Developer defined column based on SOURCE_NAME.
INFORMATION66	VARCHAR2	(255)		Developer defined column based on SOURCE_NAME.
INFORMATION67	VARCHAR2	(255)		Developer defined column based on SOURCE_NAME.
INFORMATION68	VARCHAR2	(255)		Developer defined column based on SOURCE_NAME.
INFORMATION69	VARCHAR2	(255)		Developer defined column based on SOURCE_NAME.
INFORMATION70	VARCHAR2	(255)		Developer defined column based on SOURCE_NAME.
INFORMATION71	VARCHAR2	(255)		Developer defined column based on SOURCE_NAME.
INFORMATION72	VARCHAR2	(255)		Developer defined column based on SOURCE_NAME.
INFORMATION73	VARCHAR2	(255)		Developer defined column based on SOURCE_NAME.
INFORMATION74	VARCHAR2	(255)		Developer defined column based on SOURCE_NAME.
INFORMATION75	VARCHAR2	(255)		Developer defined column based on SOURCE_NAME.
INFORMATION76	VARCHAR2	(255)		Developer defined column based on SOURCE_NAME.
INFORMATION77	VARCHAR2	(255)		Developer defined column based on SOURCE_NAME.
INFORMATION78	VARCHAR2	(255)		Developer defined column based on SOURCE_NAME.
INFORMATION79	VARCHAR2	(255)		Developer defined column based on SOURCE_NAME.
INFORMATION80	VARCHAR2	(255)		Developer defined column based on SOURCE_NAME.
INFORMATION81	VARCHAR2	(255)		Developer defined column based on SOURCE_NAME.
INFORMATION82	VARCHAR2	(255)		Developer defined column based on SOURCE_NAME.
INFORMATION83	VARCHAR2	(255)		Developer defined column based on SOURCE_NAME.
INFORMATION84	VARCHAR2	(255)		Developer defined column based on SOURCE_NAME.
INFORMATION85	VARCHAR2	(255)		Developer defined column based on SOURCE_NAME.
INFORMATION86	VARCHAR2	(255)		Developer defined column based on SOURCE_NAME.
INFORMATION87	VARCHAR2	(255)		Developer defined column based on SOURCE_NAME.
INFORMATION88	VARCHAR2	(255)		Developer defined column based on SOURCE_NAME.
INFORMATION89	VARCHAR2	(255)		Developer defined column based on SOURCE_NAME.
INFORMATION90	VARCHAR2	(255)		Developer defined column based on SOURCE_NAME.
INFORMATION91	VARCHAR2	(255)		Developer defined column based on SOURCE_NAME.
INFORMATION92	VARCHAR2	(255)		Developer defined column based on SOURCE_NAME.
INFORMATION93	VARCHAR2	(255)		Developer defined column based on SOURCE_NAME.
INFORMATION94	VARCHAR2	(255)		Developer defined column based on SOURCE_NAME.
INFORMATION95	VARCHAR2	(255)		Developer defined column based on SOURCE_NAME.
INFORMATION96	VARCHAR2	(255)		Developer defined column based on SOURCE_NAME.
INFORMATION97	VARCHAR2	(255)		Developer defined column based on SOURCE_NAME.
INFORMATION98	VARCHAR2	(255)		Developer defined column based on SOURCE_NAME.
INFORMATION99	VARCHAR2	(255)		Developer defined column based on SOURCE_NAME.
INFORMATION100	VARCHAR2	(255)		Developer defined column based on SOURCE_NAME.
INFORMATION101	VARCHAR2	(255)		Developer defined column based on SOURCE_NAME.
INFORMATION102	VARCHAR2	(255)		Developer defined column based on SOURCE_NAME.
INFORMATION103	VARCHAR2	(255)		Developer defined column based on SOURCE_NAME.
INFORMATION104	VARCHAR2	(255)		Developer defined column based on SOURCE_NAME.
INFORMATION105	VARCHAR2	(255)		Developer defined column based on SOURCE_NAME.
INFORMATION106	VARCHAR2	(255)		Developer defined column based on SOURCE_NAME.
INFORMATION107	VARCHAR2	(255)		Developer defined column based on SOURCE_NAME.
INFORMATION108	VARCHAR2	(255)		Developer defined column based on SOURCE_NAME.
INFORMATION109	VARCHAR2	(255)		Developer defined column based on SOURCE_NAME.
INFORMATION110	VARCHAR2	(255)		Developer defined column based on SOURCE_NAME.
INFORMATION111	VARCHAR2	(255)		Developer defined column based on SOURCE_NAME.
INFORMATION112	VARCHAR2	(255)		Developer defined column based on SOURCE_NAME.
INFORMATION113	VARCHAR2	(255)		Developer defined column based on SOURCE_NAME.
INFORMATION114	VARCHAR2	(255)		Developer defined column based on SOURCE_NAME.
INFORMATION115	VARCHAR2	(255)		Developer defined column based on SOURCE_NAME.
INFORMATION116	VARCHAR2	(255)		Developer defined column based on SOURCE_NAME.
INFORMATION117	VARCHAR2	(255)		Developer defined column based on SOURCE_NAME.
INFORMATION118	VARCHAR2	(255)		Developer defined column based on SOURCE_NAME.
INFORMATION119	VARCHAR2	(255)		Developer defined column based on SOURCE_NAME.
INFORMATION120	VARCHAR2	(255)		Developer defined column based on SOURCE_NAME.
INFORMATION121	VARCHAR2	(255)		Developer defined column based on SOURCE_NAME.
INFORMATION122	VARCHAR2	(255)		Developer defined column based on SOURCE_NAME.
INFORMATION123	VARCHAR2	(255)		Developer defined column based on SOURCE_NAME.
INFORMATION124	VARCHAR2	(255)		Developer defined column based on SOURCE_NAME.
INFORMATION125	VARCHAR2	(255)		Developer defined column based on SOURCE_NAME.
INFORMATION126	VARCHAR2	(255)		Developer defined column based on SOURCE_NAME.
INFORMATION127	VARCHAR2	(255)		Developer defined column based on SOURCE_NAME.
INFORMATION128	VARCHAR2	(255)		Developer defined column based on SOURCE_NAME.
INFORMATION129	VARCHAR2	(255)		Developer defined column based on SOURCE_NAME.
INFORMATION130	VARCHAR2	(255)		Developer defined column based on SOURCE_NAME.
INFORMATION131	VARCHAR2	(255)		Developer defined column based on SOURCE_NAME.
INFORMATION132	VARCHAR2	(255)		Developer defined column based on SOURCE_NAME.
INFORMATION133	VARCHAR2	(255)		Developer defined column based on SOURCE_NAME.
INFORMATION134	VARCHAR2	(255)		Developer defined column based on SOURCE_NAME.
INFORMATION135	VARCHAR2	(255)		Developer defined column based on SOURCE_NAME.
INFORMATION136	VARCHAR2	(255)		Developer defined column based on SOURCE_NAME.
INFORMATION137	VARCHAR2	(255)		Developer defined column based on SOURCE_NAME.
INFORMATION138	VARCHAR2	(255)		Developer defined column based on SOURCE_NAME.
INFORMATION139	VARCHAR2	(255)		Developer defined column based on SOURCE_NAME.
INFORMATION140	VARCHAR2	(255)		Developer defined column based on SOURCE_NAME.
INFORMATION141	VARCHAR2	(255)		Developer defined column based on SOURCE_NAME.
INFORMATION142	VARCHAR2	(255)		Developer defined column based on SOURCE_NAME.
INFORMATION143	VARCHAR2	(255)		Developer defined column based on SOURCE_NAME.
INFORMATION144	VARCHAR2	(255)		Developer defined column based on SOURCE_NAME.
INFORMATION145	VARCHAR2	(255)		Developer defined column based on SOURCE_NAME.
INFORMATION146	VARCHAR2	(255)		Developer defined column based on SOURCE_NAME.
INFORMATION147	VARCHAR2	(255)		Developer defined column based on SOURCE_NAME.
INFORMATION148	VARCHAR2	(255)		Developer defined column based on SOURCE_NAME.
INFORMATION149	VARCHAR2	(255)		Developer defined column based on SOURCE_NAME.
INFORMATION150	VARCHAR2	(255)		Developer defined column based on SOURCE_NAME.
INFORMATION151	VARCHAR2	(255)		Developer defined column based on SOURCE_NAME.
INFORMATION152	VARCHAR2	(255)		Developer defined column based on SOURCE_NAME.
INFORMATION153	VARCHAR2	(255)		Developer defined column based on SOURCE_NAME.
INFORMATION154	VARCHAR2	(255)		Developer defined column based on SOURCE_NAME.
INFORMATION155	VARCHAR2	(255)		Developer defined column based on SOURCE_NAME.
INFORMATION156	VARCHAR2	(255)		Developer defined column based on SOURCE_NAME.
INFORMATION157	VARCHAR2	(255)		Developer defined column based on SOURCE_NAME.
INFORMATION158	VARCHAR2	(255)		Developer defined column based on SOURCE_NAME.
INFORMATION159	VARCHAR2	(255)		Developer defined column based on SOURCE_NAME.
INFORMATION160	VARCHAR2	(255)		Developer defined column based on SOURCE_NAME.
INFORMATION161	VARCHAR2	(255)		Developer defined column based on SOURCE_NAME.
INFORMATION162	VARCHAR2	(255)		Developer defined column based on SOURCE_NAME.
INFORMATION163	VARCHAR2	(255)		Developer defined column based on SOURCE_NAME.
INFORMATION164	VARCHAR2	(255)		Developer defined column based on SOURCE_NAME.
INFORMATION165	VARCHAR2	(255)		Developer defined column based on SOURCE_NAME.
INFORMATION166	VARCHAR2	(255)		Developer defined column based on SOURCE_NAME.
INFORMATION167	VARCHAR2	(255)		Developer defined column based on SOURCE_NAME.
INFORMATION168	VARCHAR2	(255)		Developer defined column based on SOURCE_NAME.
INFORMATION169	VARCHAR2	(255)		Developer defined column based on SOURCE_NAME.
INFORMATION170	VARCHAR2	(255)		Developer defined column based on SOURCE_NAME.
INFORMATION171	VARCHAR2	(255)		Developer defined column based on SOURCE_NAME.
INFORMATION172	VARCHAR2	(255)		Developer defined column based on SOURCE_NAME.
INFORMATION173	VARCHAR2	(255)		Developer defined column based on SOURCE_NAME.
INFORMATION174	VARCHAR2	(255)		Developer defined column based on SOURCE_NAME.
INFORMATION175	VARCHAR2	(255)		Developer defined column based on SOURCE_NAME.
LAST_UPDATE_DATE	DATE		Yes	Standard who column.
LAST_UPDATE_LOGIN	NUMBER	(15)	Yes	Standard who column.
CREATED_BY	NUMBER	(15)		Standard who column.
CREATION_DATE	DATE		Yes	Standard who column.
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard who column.

Query Text

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


SELECT INTERFACE_ID
,      PROCESS_DATE
,      SOURCE_NAME
,      DATE_FROM
,      DATE_TO
,      INFORMATION1
,      INFORMATION2
,      INFORMATION3
,      INFORMATION4
,      INFORMATION5
,      INFORMATION6
,      INFORMATION7
,      INFORMATION8
,      INFORMATION9
,      INFORMATION10
,      INFORMATION11
,      INFORMATION12
,      INFORMATION13
,      INFORMATION14
,      INFORMATION15
,      INFORMATION16
,      INFORMATION17
,      INFORMATION18
,      INFORMATION19
,      INFORMATION20
,      INFORMATION21
,      INFORMATION22
,      INFORMATION23
,      INFORMATION24
,      INFORMATION25
,      INFORMATION26
,      INFORMATION27
,      INFORMATION28
,      INFORMATION29
,      INFORMATION30
,      INFORMATION31
,      INFORMATION32
,      INFORMATION33
,      INFORMATION34
,      INFORMATION35
,      INFORMATION36
,      INFORMATION37
,      INFORMATION38
,      INFORMATION39
,      INFORMATION40
,      INFORMATION41
,      INFORMATION42
,      INFORMATION43
,      INFORMATION44
,      INFORMATION45
,      INFORMATION46
,      INFORMATION47
,      INFORMATION48
,      INFORMATION49
,      INFORMATION50
,      INFORMATION51
,      INFORMATION52
,      INFORMATION53
,      INFORMATION54
,      INFORMATION55
,      INFORMATION56
,      INFORMATION57
,      INFORMATION58
,      INFORMATION59
,      INFORMATION60
,      INFORMATION61
,      INFORMATION62
,      INFORMATION63
,      INFORMATION64
,      INFORMATION65
,      INFORMATION66
,      INFORMATION67
,      INFORMATION68
,      INFORMATION69
,      INFORMATION70
,      INFORMATION71
,      INFORMATION72
,      INFORMATION73
,      INFORMATION74
,      INFORMATION75
,      INFORMATION76
,      INFORMATION77
,      INFORMATION78
,      INFORMATION79
,      INFORMATION80
,      INFORMATION81
,      INFORMATION82
,      INFORMATION83
,      INFORMATION84
,      INFORMATION85
,      INFORMATION86
,      INFORMATION87
,      INFORMATION88
,      INFORMATION89
,      INFORMATION90
,      INFORMATION91
,      INFORMATION92
,      INFORMATION93
,      INFORMATION94
,      INFORMATION95
,      INFORMATION96
,      INFORMATION97
,      INFORMATION98
,      INFORMATION99
,      INFORMATION100
,      INFORMATION101
,      INFORMATION102
,      INFORMATION103
,      INFORMATION104
,      INFORMATION105
,      INFORMATION106
,      INFORMATION107
,      INFORMATION108
,      INFORMATION109
,      INFORMATION110
,      INFORMATION111
,      INFORMATION112
,      INFORMATION113
,      INFORMATION114
,      INFORMATION115
,      INFORMATION116
,      INFORMATION117
,      INFORMATION118
,      INFORMATION119
,      INFORMATION120
,      INFORMATION121
,      INFORMATION122
,      INFORMATION123
,      INFORMATION124
,      INFORMATION125
,      INFORMATION126
,      INFORMATION127
,      INFORMATION128
,      INFORMATION129
,      INFORMATION130
,      INFORMATION131
,      INFORMATION132
,      INFORMATION133
,      INFORMATION134
,      INFORMATION135
,      INFORMATION136
,      INFORMATION137
,      INFORMATION138
,      INFORMATION139
,      INFORMATION140
,      INFORMATION141
,      INFORMATION142
,      INFORMATION143
,      INFORMATION144
,      INFORMATION145
,      INFORMATION146
,      INFORMATION147
,      INFORMATION148
,      INFORMATION149
,      INFORMATION150
,      INFORMATION151
,      INFORMATION152
,      INFORMATION153
,      INFORMATION154
,      INFORMATION155
,      INFORMATION156
,      INFORMATION157
,      INFORMATION158
,      INFORMATION159
,      INFORMATION160
,      INFORMATION161
,      INFORMATION162
,      INFORMATION163
,      INFORMATION164
,      INFORMATION165
,      INFORMATION166
,      INFORMATION167
,      INFORMATION168
,      INFORMATION169
,      INFORMATION170
,      INFORMATION171
,      INFORMATION172
,      INFORMATION173
,      INFORMATION174
,      INFORMATION175
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
FROM HR.GHR_INTERFACE;

Dependencies

[top of page]

HR.GHR_INTERFACE does not reference any database object

HR.GHR_INTERFACE is referenced by following:

APPS: GHR_INTERFACE; GHR_INTERFACE_WHO
PUBLIC: GHR_INTERFACE