MERCHANTIDHRS_JOB_OPENING_IDACTIONDTTMTRANSACTION_CDA=Add
D=Delete
P=Pending
U=Update
HRS_POST_LOG(SQL Table) |
Index Back |
|---|---|
Job BoardTransaction LogStores transactional data from Job Boards |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | MERCHANTID |
Character(30) | VARCHAR2(30) NOT NULL | Merchant ID |
| 2 | HRS_JOB_OPENING_ID |
Number(15,0) | DECIMAL(15) NOT NULL | Job Opening Clone |
| 3 | ACTIONDTTM |
DateTime(26) | TIMESTAMP | Datetime action was taken on a worklist |
| 4 | TRANSACTION_CD |
Character(2) | VARCHAR2(2) NOT NULL |
Action code for posting requisitions to internet
A=Add D=Delete P=Pending U=Update |
| 5 | ASSOCIATED_COST | Signed Number(10,2) | DECIMAL(8,2) NOT NULL | Associated cost of posting requisition to internet. |
| 6 | HRS_ROW_ADD_DTTM | DateTime(26) | TIMESTAMP | Row Added DateTime |
| 7 | HRS_ROW_ADD_OPRID | Character(30) | VARCHAR2(30) NOT NULL | Row Added Operator Id |
| 8 | HRS_ROW_UPD_DTTM | DateTime(26) | TIMESTAMP | Row Updated DateTime |
| 9 | HRS_ROW_UPD_OPRID | Character(30) | VARCHAR2(30) NOT NULL | Row Updated Operator Id |