Go To View:  RETURN TO REPORTING VIEW REPORTS LIST
Human Resources Reporting View Reports

SGHE Banner Operational Data Store
Reporting View Target: PAYROLL_ATTENDANCE

Description Contains attendance information pertaining to specic pay periods.
Key & Frequency One row per calendar year per payroll identifier per payroll number per person per position per suffix per effective date per earnings per attendance date

Target Column Business Definition Database Data Type Source Name Source Column
ABSENCE_DATE The Date of absence. DATE

PHRATND

PHRATND_ATND_DATE

ACTIVITY_DATE Date record was inserted or updated DATE

PHRATND

PHRATND_ACTIVITY_DATE

ADMINISTRATIVE_GROUP Organization-oriented identifier for the record used to determine access authorization to this record. Institution defined. VARCHAR2(255)

NA

NA

CALENDAR_YEAR Pay period calendar year. VARCHAR2(63)

PHRATND

PHRATND_YEAR

EARNINGS Earnings Code. VARCHAR2(63)

PHRATND

PHRATND_EARN_CODE

EARNINGS_DESC Earnings code long description. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

HOURS_ABSENT The number of hours the employee was absent on this day. NUMBER

PHRATND

PHRATND_HOURS

ID Identification number assigned to a person that is used externally for all communication and correspondence with the person. VARCHAR2(63)

FUNCTION

MGKFUNC.F_GET_PERSON_INFO

JOB_SUFFIX Suffix allows users to define a job with more precision. For example, a user could denote daytime faculty with one suffix and evening school with another. VARCHAR2(63)

PHRATND

PHRATND_SUFF

LEAVE_REASON Free form reason as to why the employee was absent. VARCHAR2(63)

PHRATND

PHRATND_LEAV_REASON

MULTI_SOURCE Institution value for the record when the optional multi-institution facility feature has been applied. VARCHAR2(63)

NA

NA

MULTI_SOURCE_DESC Institution description when the optional multi-institution facility feature has been applied. VARCHAR2(255)

NA

NA

NAME Combination of the person's first, middle initial, and last name into one value. VARCHAR2(255)

FUNCTION

MGKFUNC.F_GET_PERSON_INFO

PAYROLL_IDENTIFIER Pay identification number to which this Employee_Position belongs. VARCHAR2(63)

PHRATND

PHRATND_PICT_CODE

PAYROLL_IDENTIFIER_DESC Payroll code description or title. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

PAYROLL_NUMBER Used to uniquely identify a pay period within a fiscal year. NUMBER

PHRATND

PHRATND_PAYNO

PERSON_UID System generated unique internal identification number assigned to this person. NUMBER

PHRATND

PHRATND_PIDM

POSITION Employee Position number. VARCHAR2(63)

PHRATND

PHRATND_POSN

POSITION_BEGIN_DATE Date an Employee_Position became effective in the payroll system. DATE

PHRATND

PHRATND_EFFECTIVE_DATE

POSITION_TITLE Description of the Employee_Position. Defaults from the position title if left blank. VARCHAR2(255)

NBBPOSN

NBBPOSN_TITLE

PROCESS_GROUP Process-oriented identifier for the record used to determine access authorization to this record. Institution defined. VARCHAR2(255)

NA

NA

TIMESHEET_CHART_DESC Chart of accounts code description or title. VARCHAR2(255)

FTVCOAS

FTVCOAS_TITLE

TIMESHEET_CHART_OF_ACCOUNTS Timesheet Chart of Accounts Code VARCHAR2(63)

PHRATND

PHRATND_COAS_CODE_TS

TIMESHEET_METHOD Determines the method by which the timesheet is entered in they system. VARCHAR2(63)

PHRATND

PHRATND_TS_ROSTER_IND

TIMESHEET_METHOD_DESC Timesheet method description. VARCHAR2(255)

CALCULATION

DECODE(PHRATND_TS_ROSTER_IND)

TIMESHEET_ORGANIZATION Organization to which the time sheet for this position is sent. VARCHAR2(63)

PHRATND

PHRATND_ORGN_CODE_TS

TIMESHEET_ORGANIZATION_DESC Organization to which this Employee_Position's time sheet is sent. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC



Ver: 8.0