Briefly explain the concept of effective date and its advantages

Effective date concept is used in multiple core tables in PS HRMS. For example in job this is a primary key. Purpose of this field is to d...

Effective date concept is used in multiple core tables in PS HRMS. For example in job this is a primary key. Purpose of this field is to differentiate multiple transaction rows for same employee that has happened on two different dates. Effective date is also used in a lot of setup tables for example location. A location is say active as of today but 5 days later if I wish to make it inactive how does the system recognize the current status of location 5 days in future. It will be done by using the most effective dated row for that location

COMMENTS

Name

PeopleSoft HCM HRMS Interview Questions PeopleSoft HRMS Interview Questions PeopleSoft Interview Questions
false
ltr
item
PeopleSoft Online Training: Briefly explain the concept of effective date and its advantages
Briefly explain the concept of effective date and its advantages
PeopleSoft Online Training
https://peoplesoftonlinelearning.blogspot.com/2016/11/briefly-explain-concept-of-effective.html
https://peoplesoftonlinelearning.blogspot.com/
https://peoplesoftonlinelearning.blogspot.com/
https://peoplesoftonlinelearning.blogspot.com/2016/11/briefly-explain-concept-of-effective.html
true
8010478567507321031
UTF-8
Not found any posts VIEW ALL Readmore Reply Cancel reply Delete By Home PAGES POSTS View All RECOMMENDED FOR YOU LABEL ARCHIVE SEARCH ALL POSTS Not found any post match with your request Back Home Sunday Monday Tuesday Wednesday Thursday Friday Saturday Sun Mon Tue Wed Thu Fri Sat January February March April May June July August September October November December Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec just now 1 minute ago $$1$$ minutes ago 1 hour ago $$1$$ hours ago Yesterday $$1$$ days ago $$1$$ weeks ago more than 5 weeks ago Followers Follow THIS CONTENT IS PREMIUM Please share to unlock Copy All Code Select All Code All codes were copied to your clipboard Can not copy the codes / texts, please press [CTRL]+[C] (or CMD+C with Mac) to copy