In this article we will look into how to get the Time Card Required Flag using a SQL Query.
Time Card Required Flag can be seen on the Payroll Relationship Task under the Person Management screen.
SQL Query:
SELECT PPNF.FULL_NAME,
PAPF.PERSON_NUMBER,
PPRD.PAYROLL_RELATIONSHIP_NUMBER,
PPRD.START_DATE,
PPRD.END_DATE,
PAPSF.TIME_CARD_REQ,
PLDG.LEGISLATION_CODE,
PJ.NAME JOB,
PD.NAME DEPARTMENT,
PAPRF.PAYROLL_NAME PAYROLL_NAME
FROM PER_ALL_PEOPLE_F PAPF,
PER_PERSON_NAMES_F PPNF,
PAY_PAY_RELATIONSHIPS_DN PPRD,
PER_ALL_ASSIGNMENTS_F PAAF,
PAY_ASSIGNED_PAYROLLS_DN PAPD,
PAY_ASSIGNED_PAYROLLS_F PAPSF,
PAY_ALL_PAYROLLS_F PAPRF,
PER_JOBS PJ,
PER_DEPARTMENTS PD,
PAY_PAYROLL_ASSIGNMENTS PPA,
PER_LEGISLATIVE_DATA_GROUPS PLDG
WHERE PAPF.PERSON_ID = PPNF.PERSON_ID
AND PPNF.NAME_TYPE = 'GLOBAL'
AND PAPF.PERSON_ID = PPRD.PERSON_ID
AND PAPF.PERSON_ID = PAAF.PERSON_ID
AND paaf.assignment_status_type = 'ACTIVE'
AND PAAF.PRIMARY_FLAG = 'Y'
AND PAAF.ASSIGNMENT_TYPE = 'E'
AND PAPRF.PAYROLL_ID = PAPD.PAYROLL_ID
AND PAPD.ASSIGNED_PAYROLL_ID = PAPSF.ASSIGNED_PAYROLL_ID
AND PPRD.LEGISLATIVE_DATA_GROUP_ID = PLDG.LEGISLATIVE_DATA_GROUP_ID(+)
AND PAPD.PAYROLL_TERM_ID = PPA.PAYROLL_TERM_ID(+)
AND PPRD.PAYROLL_RELATIONSHIP_ID = PPA.PAYROLL_RELATIONSHIP_ID
AND PAAF.JOB_ID = PJ.JOB_ID(+)
AND PAAF.ORGANIZATION_ID = PD.ORGANIZATION_ID(+)
AND TRUNC(SYSDATE) BETWEEN PAPF.EFFECTIVE_START_DATE
AND PAPF.EFFECTIVE_END_DATE
AND TRUNC(SYSDATE) BETWEEN PPNF.EFFECTIVE_START_DATE
AND PPNF.EFFECTIVE_END_DATE
AND TRUNC(SYSDATE) BETWEEN PAAF.EFFECTIVE_START_DATE
AND PAAF.EFFECTIVE_END_DATE
AND TRUNC(SYSDATE) BETWEEN PAPSF.EFFECTIVE_START_DATE
AND PAPSF.EFFECTIVE_END_DATE
AND TRUNC(SYSDATE) BETWEEN PAPRF.EFFECTIVE_START_DATE
AND PAPRF.EFFECTIVE_END_DATE
