[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: |
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 |
GHR_PA_HISTORY_N4 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX |
TABLE_NAME
ASSIGNMENT_ID EFFECTIVE_DATE |
Table | |
Foreign Table | Foreign Key Column | 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:
|
|
|