• Post category:BI Publisher
  • Post comments:0 Comments
  • Post last modified:April 19, 2021
  • Reading time:3 mins read
You are currently viewing SQL Query to get the Payroll Name, Time Card Required Flag from Payroll Relationship Screen
SQL Query to get the Time Card Required Flag from Payroll Relationship Screen

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.

image 40 - SQL Query to get the Payroll Name, Time Card Required Flag from Payroll Relationship 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
image 38 1024x392 - SQL Query to get the Payroll Name, Time Card Required Flag from Payroll Relationship Screen
If you like the content, please follow us on LinkedInFacebook, and Twitter to get updated with the latest content.