I am currently working on a requirement to insert/update/delete some Job related SIT info. This SIT screen would open when we click on the requirements button Job form in works structures.
Generally person related SIT data is stored in per_person_analyses and per_analysis_criteria tables, which is known to most of us. But what about Job related SIT?
In case of Job related SIT, data is stored in 2 tables- per_analysis_criteria and the other table is per_job_requirements. You will not find the analysis_criteria_id in per_person_analyses table, but you can find the same in per_job_requirements table.
per_analysis_criteria,per_job_requirements---join and query them and check the output.
Generally person related SIT data is stored in per_person_analyses and per_analysis_criteria tables, which is known to most of us. But what about Job related SIT?
In case of Job related SIT, data is stored in 2 tables- per_analysis_criteria and the other table is per_job_requirements. You will not find the analysis_criteria_id in per_person_analyses table, but you can find the same in per_job_requirements table.
per_analysis_criteria,per_job_requirements---join and query them and check the output.
No comments:
Post a Comment