Created on Brad's Behalf: We are pulling data from PeopleSoft General Ledger Journal tables to our
Hi All,
We are pulling data from PeopleSoft General Ledger Journal tables to our internal data warehouse...currently we are using JRNL_HEADER and JRNL_LN. We run for a set date..ie 12/31/2013 and where the journal header status = P.
But we are finding we are missing data because users will sometimes back date journal entries...since our next run will be for 1/1/2014. If something new was entered for a date prior that that date, the data is not picked up.
We were trying to identify a better date to use requesting data..we have tried using the 4 main dates ( Journal_Date, Posted_Date, Transaction_Date and Create_Date), there are transactions where any of these dates can be before or after any other of these dates...so we are not sure how to isolate to just picking up the new data.
We are pulling data from PeopleSoft General Ledger Journal tables to our internal data warehouse...currently we are using JRNL_HEADER and JRNL_LN. We run for a set date..ie 12/31/2013 and where the journal header status = P.
But we are finding we are missing data because users will sometimes back date journal entries...since our next run will be for 1/1/2014. If something new was entered for a date prior that that date, the data is not picked up.
We were trying to identify a better date to use requesting data..we have tried using the 4 main dates ( Journal_Date, Posted_Date, Transaction_Date and Create_Date), there are transactions where any of these dates can be before or after any other of these dates...so we are not sure how to isolate to just picking up the new data.
1