[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | GHR_PA_HISTORY |
|---|---|
| Object Type: | TABLE |
| Owner: | HR |
| FND Design Data: |  GHR.GHR_PA_HISTORY
|
| Subobject Name: | |
| Status: | VALID |
Stores the history of all the transations, the nature of DML
Operation , process date, specific details of
the RPA if the changes take place due to an RPA Process etc for the
follwing tables.
PER_PEOPLE_F,
PER_ASSIGNMENTS_F,
PER_POSITIONS,
PAY_ELEMENT_ENTRIES_F,
PAY_ELEMENT_ENTRY_VALUES_F,
PER_ADDRESSES,
PER_PERSON_ANALYSES,
PER_PEOPLE_EXTRA_INFO,
PER_ASSIGNMENT_EXTRA_INFO,
PER_POSITION_EXTRA_INFO
| Tablespace: |  APPS_TS_TX_DATA |
|---|---|
| PCT Free: | 0 |
| PCT Used: |
PA_HISTORY_ID| Index | Type | Uniqueness | Tablespace | Column |
|---|---|---|---|---|
| GHR_PA_HISTORY_PK | NORMAL | UNIQUE |
APPS_TS_TX_IDX
|
PA_HISTORY_ID
|
| GHR_PA_HISTORY_FK1 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
NATURE_OF_ACTION_ID
|
| GHR_PA_HISTORY_FK2 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
PA_REQUEST_ID
|
| GHR_PA_HISTORY_FK3 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
ALTERED_PA_REQUEST_ID
|
| GHR_PA_HISTORY_N1 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
TABLE_NAME
INFORMATION1
|
| GHR_PA_HISTORY_N2 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
TABLE_NAME
INFORMATION5
EFFECTIVE_DATE
|
| GHR_PA_HISTORY_N3 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
PERSON_ID
TABLE_NAME
INFORMATION5
|
| Table | |
Foreign Table | Foreign Key Column | GHR_PA_HISTORY |  |
GHR_NATURE_OF_ACTIONS
|
GHR_PA_HISTORY NATURE_OF_ACTION_ID | GHR_PA_HISTORY | |
GHR_PA_REQUESTS
|
GHR_PA_HISTORY ALTERED_PA_REQUEST_ID | GHR_PA_HISTORY | |
GHR_PA_REQUESTS
|
GHR_PA_HISTORY PA_REQUEST_ID |
|---|
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| PA_HISTORY_ID | NUMBER | (15) | Yes | Primary key generated from sequence GHR_PA_HISTORY_S. |
| PA_REQUEST_ID | NUMBER | (15) | Foreign key to GHR_PA_REQUESTS. | |
| PROCESS_DATE | DATE | Yes | Date on which this information was processed. | |
| NATURE_OF_ACTION_ID | NUMBER | (15) | Foreign key to GHR_NATURE_OF_ACTIONS. | |
| EFFECTIVE_DATE | DATE | Yes | Effective date for request for personnel action. | |
| ALTERED_PA_REQUEST_ID | NUMBER | (15) | Foreign key to GHR_PA_REQUESTS | |
| PERSON_ID | NUMBER | (10) | Foreign key to PER_PEOPLE_F. | |
| ASSIGNMENT_ID | NUMBER | (10) | Foreign key to PER_ASSIGNMENTS_F. | |
| DML_OPERATION | VARCHAR2 | (1) | Indicates whether this record was created or updated by last data manipulation language operation. | |
| TABLE_NAME | VARCHAR2 | (30) | Yes | Name of the table to which this record belongs. |
| PRE_VALUES_FLAG | VARCHAR2 | (1) | Indicates whether there is another record prior to this record. | |
| INFORMATION1 | VARCHAR2 | (255) | Stores the Primary Key of the corresponding record of the table for which history is maintained. | |
| INFORMATION2 | VARCHAR2 | (255) | Stores the effective start date of the corresponding record of a date tracked table for which history is maintained. | |
| INFORMATION3 | VARCHAR2 | (255) | Stores the effective start date of the corresponding record of a date tracked table for which history is maintained. | |
| INFORMATION4 | VARCHAR2 | (255) | Developer defined column based on TABLE_NAME. | |
| INFORMATION5 | VARCHAR2 | (255) | Developer defined column based on TABLE_NAME. | |
| INFORMATION6 | VARCHAR2 | (255) | Developer defined column based on TABLE_NAME. | |
| INFORMATION7 | VARCHAR2 | (255) | Developer defined column based on TABLE_NAME. | |
| INFORMATION8 | VARCHAR2 | (255) | Developer defined column based on TABLE_NAME. | |
| INFORMATION9 | VARCHAR2 | (255) | Developer defined column based on TABLE_NAME. | |
| INFORMATION10 | VARCHAR2 | (255) | Developer defined column based on TABLE_NAME. | |
| INFORMATION11 | VARCHAR2 | (255) | Developer defined column based on TABLE_NAME. | |
| INFORMATION12 | VARCHAR2 | (255) | Developer defined column based on TABLE_NAME. | |
| INFORMATION13 | VARCHAR2 | (255) | Developer defined column based on TABLE_NAME. | |
| INFORMATION14 | VARCHAR2 | (255) | Developer defined column based on TABLE_NAME. | |
| INFORMATION15 | VARCHAR2 | (255) | Developer defined column based on TABLE_NAME. | |
| INFORMATION16 | VARCHAR2 | (255) | Developer defined column based on TABLE_NAME. | |
| INFORMATION17 | VARCHAR2 | (255) | Developer defined column based on TABLE_NAME. | |
| INFORMATION18 | VARCHAR2 | (255) | Developer defined column based on TABLE_NAME. | |
| INFORMATION19 | VARCHAR2 | (255) | Developer defined column based on TABLE_NAME. | |
| INFORMATION20 | VARCHAR2 | (255) | Developer defined column based on TABLE_NAME. | |
| INFORMATION21 | VARCHAR2 | (255) | Developer defined column based on TABLE_NAME. | |
| INFORMATION22 | VARCHAR2 | (255) | Developer defined column based on TABLE_NAME. | |
| INFORMATION23 | VARCHAR2 | (255) | Developer defined column based on TABLE_NAME. | |
| INFORMATION24 | VARCHAR2 | (255) | Developer defined column based on TABLE_NAME. | |
| INFORMATION25 | VARCHAR2 | (255) | Developer defined column based on TABLE_NAME. | |
| INFORMATION26 | VARCHAR2 | (255) | Developer defined column based on TABLE_NAME. | |
| INFORMATION27 | VARCHAR2 | (255) | Developer defined column based on TABLE_NAME. | |
| INFORMATION28 | VARCHAR2 | (255) | Developer defined column based on TABLE_NAME. | |
| INFORMATION29 | VARCHAR2 | (255) | Developer defined column based on TABLE_NAME. | |
| INFORMATION30 | VARCHAR2 | (255) | Developer defined column based on TABLE_NAME. | |
| INFORMATION31 | VARCHAR2 | (255) | Developer defined column based on TABLE_NAME. | |
| INFORMATION32 | VARCHAR2 | (255) | Developer defined column based on TABLE_NAME. | |
| INFORMATION33 | VARCHAR2 | (255) | Developer defined column based on TABLE_NAME. | |
| INFORMATION34 | VARCHAR2 | (255) | Developer defined column based on TABLE_NAME. | |
| INFORMATION35 | VARCHAR2 | (255) | Developer defined column based on TABLE_NAME. | |
| INFORMATION36 | VARCHAR2 | (255) | Developer defined column based on TABLE_NAME. | |
| INFORMATION37 | VARCHAR2 | (255) | Developer defined column based on TABLE_NAME. | |
| INFORMATION38 | VARCHAR2 | (255) | Developer defined column based on TABLE_NAME. | |
| INFORMATION39 | VARCHAR2 | (255) | Developer defined column based on TABLE_NAME. | |
| INFORMATION47 | VARCHAR2 | (255) | Developer defined column based on TABLE_NAME. | |
| INFORMATION48 | VARCHAR2 | (255) | Developer defined column based on TABLE_NAME. | |
| INFORMATION49 | VARCHAR2 | (255) | Developer defined column based on TABLE_NAME. | |
| INFORMATION40 | VARCHAR2 | (255) | Developer defined column based on TABLE_NAME. | |
| INFORMATION41 | VARCHAR2 | (255) | Developer defined column based on TABLE_NAME. | |
| INFORMATION42 | VARCHAR2 | (255) | Developer defined column based on TABLE_NAME. | |
| INFORMATION43 | VARCHAR2 | (255) | Developer defined column based on TABLE_NAME. | |
| INFORMATION44 | VARCHAR2 | (255) | Developer defined column based on TABLE_NAME. | |
| INFORMATION45 | VARCHAR2 | (255) | Developer defined column based on TABLE_NAME. | |
| INFORMATION46 | VARCHAR2 | (255) | Developer defined column based on TABLE_NAME. | |
| INFORMATION50 | VARCHAR2 | (255) | Developer defined column based on TABLE_NAME. | |
| INFORMATION51 | VARCHAR2 | (255) | Developer defined column based on TABLE_NAME. | |
| INFORMATION52 | VARCHAR2 | (255) | Developer defined column based on TABLE_NAME. | |
| INFORMATION53 | VARCHAR2 | (255) | Developer defined column based on TABLE_NAME. | |
| INFORMATION54 | VARCHAR2 | (255) | Developer defined column based on TABLE_NAME. | |
| INFORMATION55 | VARCHAR2 | (255) | Developer defined column based on TABLE_NAME. | |
| INFORMATION56 | VARCHAR2 | (255) | Developer defined column based on TABLE_NAME. | |
| INFORMATION57 | VARCHAR2 | (255) | Developer defined column based on TABLE_NAME. | |
| INFORMATION58 | VARCHAR2 | (255) | Developer defined column based on TABLE_NAME. | |
| INFORMATION59 | VARCHAR2 | (255) | Developer defined column based on TABLE_NAME. | |
| INFORMATION60 | VARCHAR2 | (255) | Developer defined column based on TABLE_NAME. | |
| INFORMATION61 | VARCHAR2 | (255) | Developer defined column based on TABLE_NAME. | |
| INFORMATION62 | VARCHAR2 | (255) | Developer defined column based on TABLE_NAME. | |
| INFORMATION63 | VARCHAR2 | (255) | Developer defined column based on TABLE_NAME. | |
| INFORMATION64 | VARCHAR2 | (255) | Developer defined column based on TABLE_NAME. | |
| INFORMATION65 | VARCHAR2 | (255) | Developer defined column based on TABLE_NAME. | |
| INFORMATION66 | VARCHAR2 | (255) | Developer defined column based on TABLE_NAME. | |
| INFORMATION67 | VARCHAR2 | (255) | Developer defined column based on TABLE_NAME. | |
| INFORMATION68 | VARCHAR2 | (255) | Developer defined column based on TABLE_NAME. | |
| INFORMATION69 | VARCHAR2 | (255) | Developer defined column based on TABLE_NAME. | |
| INFORMATION70 | VARCHAR2 | (255) | Developer defined column based on TABLE_NAME. | |
| INFORMATION71 | VARCHAR2 | (255) | Developer defined column based on TABLE_NAME. | |
| INFORMATION72 | VARCHAR2 | (255) | Developer defined column based on TABLE_NAME. | |
| INFORMATION73 | VARCHAR2 | (255) | Developer defined column based on TABLE_NAME. | |
| INFORMATION74 | VARCHAR2 | (255) | Developer defined column based on TABLE_NAME. | |
| INFORMATION75 | VARCHAR2 | (255) | Developer defined column based on TABLE_NAME. | |
| INFORMATION76 | VARCHAR2 | (255) | Developer defined column based on TABLE_NAME. | |
| INFORMATION77 | VARCHAR2 | (255) | Developer defined column based on TABLE_NAME. | |
| INFORMATION78 | VARCHAR2 | (255) | Developer defined column based on TABLE_NAME. | |
| INFORMATION79 | VARCHAR2 | (255) | Developer defined column based on TABLE_NAME. | |
| INFORMATION80 | VARCHAR2 | (255) | Developer defined column based on TABLE_NAME. | |
| INFORMATION81 | VARCHAR2 | (255) | Developer defined column based on TABLE_NAME. | |
| INFORMATION82 | VARCHAR2 | (255) | Developer defined column based on TABLE_NAME. | |
| INFORMATION83 | VARCHAR2 | (255) | Developer defined column based on TABLE_NAME. | |
| INFORMATION84 | VARCHAR2 | (255) | Developer defined column based on TABLE_NAME. | |
| INFORMATION85 | VARCHAR2 | (255) | Developer defined column based on TABLE_NAME. | |
| INFORMATION86 | VARCHAR2 | (255) | Developer defined column based on TABLE_NAME. | |
| INFORMATION87 | VARCHAR2 | (255) | Developer defined column based on TABLE_NAME. | |
| INFORMATION88 | VARCHAR2 | (255) | Developer defined column based on TABLE_NAME. | |
| INFORMATION89 | VARCHAR2 | (255) | Developer defined column based on TABLE_NAME. | |
| INFORMATION90 | VARCHAR2 | (255) | Developer defined column based on TABLE_NAME. | |
| INFORMATION91 | VARCHAR2 | (255) | Developer defined column based on TABLE_NAME. | |
| INFORMATION92 | VARCHAR2 | (255) | Developer defined column based on TABLE_NAME. | |
| INFORMATION93 | VARCHAR2 | (255) | Developer defined column based on TABLE_NAME. | |
| INFORMATION94 | VARCHAR2 | (255) | Developer defined column based on TABLE_NAME. | |
| INFORMATION95 | VARCHAR2 | (255) | Developer defined column based on TABLE_NAME. | |
| INFORMATION96 | VARCHAR2 | (255) | Developer defined column based on TABLE_NAME. | |
| INFORMATION97 | VARCHAR2 | (255) | Developer defined column based on TABLE_NAME. | |
| INFORMATION98 | VARCHAR2 | (255) | Developer defined column based on TABLE_NAME. | |
| INFORMATION99 | VARCHAR2 | (255) | Developer defined column based on TABLE_NAME. | |
| INFORMATION100 | VARCHAR2 | (255) | Developer defined column based on TABLE_NAME. | |
| INFORMATION101 | VARCHAR2 | (255) | Developer defined column based on TABLE_NAME. | |
| INFORMATION102 | VARCHAR2 | (255) | Developer defined column based on TABLE_NAME. | |
| INFORMATION103 | VARCHAR2 | (255) | Developer defined column based on TABLE_NAME. | |
| INFORMATION104 | VARCHAR2 | (255) | Developer defined column based on TABLE_NAME. | |
| INFORMATION105 | VARCHAR2 | (255) | Developer defined column based on TABLE_NAME. | |
| INFORMATION106 | VARCHAR2 | (255) | Developer defined column based on TABLE_NAME. | |
| INFORMATION107 | VARCHAR2 | (255) | Developer defined column based on TABLE_NAME. | |
| INFORMATION108 | VARCHAR2 | (255) | Developer defined column based on TABLE_NAME. | |
| INFORMATION109 | VARCHAR2 | (255) | Developer defined column based on TABLE_NAME. | |
| INFORMATION110 | VARCHAR2 | (255) | Developer defined column based on TABLE_NAME. | |
| INFORMATION111 | VARCHAR2 | (255) | Developer defined column based on TABLE_NAME. | |
| INFORMATION112 | VARCHAR2 | (255) | Developer defined column based on TABLE_NAME. | |
| INFORMATION113 | VARCHAR2 | (255) | Developer defined column based on TABLE_NAME. | |
| INFORMATION114 | VARCHAR2 | (255) | Developer defined column based on TABLE_NAME. | |
| INFORMATION115 | VARCHAR2 | (255) | Developer defined column based on TABLE_NAME. | |
| INFORMATION116 | VARCHAR2 | (255) | Developer defined column based on TABLE_NAME. | |
| INFORMATION117 | VARCHAR2 | (255) | Developer defined column based on TABLE_NAME. | |
| INFORMATION118 | VARCHAR2 | (255) | Developer defined column based on TABLE_NAME. | |
| INFORMATION119 | VARCHAR2 | (255) | Developer defined column based on TABLE_NAME. | |
| INFORMATION120 | VARCHAR2 | (255) | Developer defined column based on TABLE_NAME. | |
| INFORMATION121 | VARCHAR2 | (255) | Developer defined column based on TABLE_NAME. | |
| INFORMATION122 | VARCHAR2 | (255) | Developer defined column based on TABLE_NAME. | |
| INFORMATION123 | VARCHAR2 | (255) | Developer defined column based on TABLE_NAME. | |
| INFORMATION124 | VARCHAR2 | (255) | Developer defined column based on TABLE_NAME. | |
| INFORMATION125 | VARCHAR2 | (255) | Developer defined column based on TABLE_NAME. | |
| INFORMATION126 | VARCHAR2 | (255) | Developer defined column based on TABLE_NAME. | |
| INFORMATION127 | VARCHAR2 | (255) | Developer defined column based on TABLE_NAME. | |
| INFORMATION128 | VARCHAR2 | (255) | Developer defined column based on TABLE_NAME. | |
| INFORMATION129 | VARCHAR2 | (255) | Developer defined column based on TABLE_NAME. | |
| INFORMATION130 | VARCHAR2 | (255) | Developer defined column based on TABLE_NAME. | |
| INFORMATION131 | VARCHAR2 | (255) | Developer defined column based on TABLE_NAME. | |
| INFORMATION132 | VARCHAR2 | (255) | Developer defined column based on TABLE_NAME. | |
| INFORMATION133 | VARCHAR2 | (255) | Developer defined column based on TABLE_NAME. | |
| INFORMATION134 | VARCHAR2 | (255) | Developer defined column based on TABLE_NAME. | |
| INFORMATION135 | VARCHAR2 | (255) | Developer defined column based on TABLE_NAME. | |
| INFORMATION136 | VARCHAR2 | (255) | Developer defined column based on TABLE_NAME. | |
| INFORMATION137 | VARCHAR2 | (255) | Developer defined column based on TABLE_NAME. | |
| INFORMATION138 | VARCHAR2 | (255) | Developer defined column based on TABLE_NAME. | |
| INFORMATION139 | VARCHAR2 | (255) | Developer defined column based on TABLE_NAME. | |
| INFORMATION140 | VARCHAR2 | (255) | Developer defined column based on TABLE_NAME. | |
| INFORMATION141 | VARCHAR2 | (255) | Developer defined column based on TABLE_NAME. | |
| INFORMATION142 | VARCHAR2 | (255) | Developer defined column based on TABLE_NAME. | |
| INFORMATION143 | VARCHAR2 | (255) | Developer defined column based on TABLE_NAME. | |
| INFORMATION144 | VARCHAR2 | (255) | Developer defined column based on TABLE_NAME. | |
| INFORMATION145 | VARCHAR2 | (255) | Developer defined column based on TABLE_NAME. | |
| INFORMATION146 | VARCHAR2 | (255) | Developer defined column based on TABLE_NAME. | |
| INFORMATION147 | VARCHAR2 | (255) | Developer defined column based on TABLE_NAME. | |
| INFORMATION148 | VARCHAR2 | (255) | Developer defined column based on TABLE_NAME. | |
| INFORMATION149 | VARCHAR2 | (255) | Developer defined column based on TABLE_NAME. | |
| INFORMATION150 | VARCHAR2 | (255) | Developer defined column based on TABLE_NAME. | |
| INFORMATION151 | VARCHAR2 | (255) | Developer defined column based on TABLE_NAME. | |
| INFORMATION152 | VARCHAR2 | (255) | Developer defined column based on TABLE_NAME. | |
| INFORMATION153 | VARCHAR2 | (255) | Developer defined column based on TABLE_NAME. | |
| INFORMATION154 | VARCHAR2 | (255) | Developer defined column based on TABLE_NAME. | |
| INFORMATION155 | VARCHAR2 | (255) | Developer defined column based on TABLE_NAME. | |
| INFORMATION156 | VARCHAR2 | (255) | Developer defined column based on TABLE_NAME. | |
| INFORMATION157 | VARCHAR2 | (255) | Developer defined column based on TABLE_NAME. | |
| INFORMATION158 | VARCHAR2 | (255) | Developer defined column based on TABLE_NAME. | |
| INFORMATION159 | VARCHAR2 | (255) | Developer defined column based on TABLE_NAME. | |
| INFORMATION160 | VARCHAR2 | (255) | Developer defined column based on TABLE_NAME. | |
| INFORMATION161 | VARCHAR2 | (255) | Developer defined column based on TABLE_NAME. | |
| INFORMATION162 | VARCHAR2 | (255) | Developer defined column based on TABLE_NAME. | |
| INFORMATION163 | VARCHAR2 | (255) | Developer defined column based on TABLE_NAME. | |
| INFORMATION164 | VARCHAR2 | (255) | Developer defined column based on TABLE_NAME. | |
| INFORMATION165 | VARCHAR2 | (255) | Developer defined column based on TABLE_NAME. | |
| INFORMATION166 | VARCHAR2 | (255) | Developer defined column based on TABLE_NAME. | |
| INFORMATION167 | VARCHAR2 | (255) | Developer defined column based on TABLE_NAME. | |
| INFORMATION168 | VARCHAR2 | (255) | Developer defined column based on TABLE_NAME. | |
| INFORMATION169 | VARCHAR2 | (255) | Developer defined column based on TABLE_NAME. | |
| INFORMATION170 | VARCHAR2 | (255) | Developer defined column based on TABLE_NAME. | |
| INFORMATION171 | VARCHAR2 | (255) | Developer defined column based on TABLE_NAME. | |
| INFORMATION172 | VARCHAR2 | (255) | Developer defined column based on TABLE_NAME. | |
| INFORMATION173 | VARCHAR2 | (255) | Developer defined column based on TABLE_NAME. | |
| INFORMATION174 | VARCHAR2 | (255) | Developer defined column based on TABLE_NAME. | |
| INFORMATION175 | VARCHAR2 | (255) | Developer defined column based on TABLE_NAME. | |
| INFORMATION176 | VARCHAR2 | (255) | Developer defined column based on TABLE_NAME. | |
| INFORMATION177 | VARCHAR2 | (255) | Developer defined column based on TABLE_NAME. | |
| INFORMATION178 | VARCHAR2 | (255) | Developer defined column based on TABLE_NAME. | |
| INFORMATION179 | VARCHAR2 | (255) | Developer defined column based on TABLE_NAME. | |
| INFORMATION180 | VARCHAR2 | (255) | Developer defined column based on TABLE_NAME. | |
| INFORMATION181 | VARCHAR2 | (255) | Developer defined column based on TABLE_NAME. | |
| INFORMATION182 | VARCHAR2 | (255) | Developer defined column based on TABLE_NAME. | |
| INFORMATION183 | VARCHAR2 | (255) | Developer defined column based on TABLE_NAME. | |
| INFORMATION184 | VARCHAR2 | (255) | Developer defined column based on TABLE_NAME. | |
| INFORMATION185 | VARCHAR2 | (255) | Developer defined column based on TABLE_NAME. | |
| INFORMATION186 | VARCHAR2 | (255) | Developer defined column based on TABLE_NAME. | |
| INFORMATION187 | VARCHAR2 | (255) | Developer defined column based on TABLE_NAME. | |
| INFORMATION188 | VARCHAR2 | (255) | Developer defined column based on TABLE_NAME. | |
| INFORMATION189 | VARCHAR2 | (255) | Developer defined column based on TABLE_NAME. | |
| INFORMATION190 | VARCHAR2 | (255) | Developer defined column based on TABLE_NAME. | |
| INFORMATION191 | VARCHAR2 | (255) | Developer defined column based on TABLE_NAME. | |
| INFORMATION192 | VARCHAR2 | (255) | Developer defined column based on TABLE_NAME. | |
| INFORMATION193 | VARCHAR2 | (255) | Developer defined column based on TABLE_NAME. | |
| INFORMATION194 | VARCHAR2 | (255) | Developer defined column based on TABLE_NAME. | |
| INFORMATION195 | VARCHAR2 | (255) | Developer defined column based on TABLE_NAME. | |
| INFORMATION196 | VARCHAR2 | (255) | Developer defined column based on TABLE_NAME. | |
| INFORMATION197 | VARCHAR2 | (255) | Developer defined column based on TABLE_NAME. | |
| INFORMATION198 | VARCHAR2 | (255) | Developer defined column based on TABLE_NAME. | |
| INFORMATION199 | VARCHAR2 | (255) | Developer defined column based on TABLE_NAME. | |
| INFORMATION200 | VARCHAR2 | (255) | Developer defined column based on TABLE_NAME. | |
| LAST_UPDATE_DATE | DATE | Yes | Standard who column. | |
| LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard who column. |
| LAST_UPDATE_LOGIN | NUMBER | (15) | Standard who column. | |
| CREATED_BY | NUMBER | (15) | Yes | Standard who column. |
| CREATION_DATE | DATE | Yes | Standard who column. |
Cut, paste (and edit) the following text to query this object:
SELECT PA_HISTORY_ID
, PA_REQUEST_ID
, PROCESS_DATE
, NATURE_OF_ACTION_ID
, EFFECTIVE_DATE
, ALTERED_PA_REQUEST_ID
, PERSON_ID
, ASSIGNMENT_ID
, DML_OPERATION
, TABLE_NAME
, PRE_VALUES_FLAG
, 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
, INFORMATION47
, INFORMATION48
, INFORMATION49
, INFORMATION40
, INFORMATION41
, INFORMATION42
, INFORMATION43
, INFORMATION44
, INFORMATION45
, INFORMATION46
, 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
, INFORMATION176
, INFORMATION177
, INFORMATION178
, INFORMATION179
, INFORMATION180
, INFORMATION181
, INFORMATION182
, INFORMATION183
, INFORMATION184
, INFORMATION185
, INFORMATION186
, INFORMATION187
, INFORMATION188
, INFORMATION189
, INFORMATION190
, INFORMATION191
, INFORMATION192
, INFORMATION193
, INFORMATION194
, INFORMATION195
, INFORMATION196
, INFORMATION197
, INFORMATION198
, INFORMATION199
, INFORMATION200
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, CREATED_BY
, CREATION_DATE
FROM HR.GHR_PA_HISTORY;
HR.GHR_PA_HISTORY does not reference any database object
HR.GHR_PA_HISTORY is referenced by following:
APPS
GHR_PA_HISTORY
GHR_PA_HISTORY_WHO
PUBLIC
GHR_PA_HISTORY
|
|
|
|