| Data element |
Definition |
FISCAL_YEAR
Indexed - yes
Format - char (4)
May be null? yes |
The fiscal year during which the employee was paid the FY_Payment_Amount
from the Posted_COA_Account. Penn's fiscal year begins July 1 of one year
and ends June 30 of the next year.
Example: 2000 (the fiscal year that began July 1, 1999, and ended June
30, 2000)
|
FY_PAYMENT_AMOUNT
Indexed - no
Format - number (8,2)
May be null? yes |
The total amount paid to the employee from the Posted_COA_Account
during the Fiscal_Year.
Values:
-9,999,999.99 - 9,999,999.99
|
HOME_DEPT
Indexed - yes
Format - char (5)
May be null? yes
|
The 5-digit Payroll code identifying the department that owns
the employee's record and is responsible for its maintenance. Since there
is only one record per person per account per fiscal year, although payment
totals are updated, Home_Dept is only loaded once. For example, if a person
moves within the fiscal year, but is paid from the same account combination,
Home_Dept will retain its original values for the fiscal year. Department
numbers in the Personnel/Payroll and related systems were converted to four-digit
organization codes on July 16, 1999. All records after that date will have
null values for Home_Dept; Home_Dept_Org should be used in its place.
Example: 17101 (Data Administration)
Values:
Refer to the DWADMIN.ORG_OLD_TO_NEW table for values.
|
HOME_DEPT_ORG
Indexed - yes
Format - char (4)
May be null? yes
|
The 4-digit number that represents the Organization that owns
the employee's record and is responsible for its maintenance. Since there
is only one record per person per account per fiscal year, although payment
totals are updated, Home_Dept_Org is only loaded once. For example, if a
person moves within the fiscal year, but is paid from the same account combination,
Home_Dept_Org will retain its original values for the fiscal year. An organization
is a subdivision of the University created for management purposes. An Organization
belongs to only one School or Responsibility Center, and its organization
code is unique. (The code set is from the University's General Ledger, and
has been in use since July 1, 1996.)
Examples: 0104 (CHEMISTRY); 0001 (GEN UNIVERSITY)
Values:
Refer to the DWADMIN.ORG_CODES table for values.
|
HOME_SCHOOL
Indexed - yes
Format - char (2)
May be null? yes
|
The 2-digit Payroll code used to identify the school or center
that owns the employee's record and is responsible for its maintenance.
Since there is only one record per person per account per fiscal year, although
payment totals are updated, Home_School is only loaded once. For example,
if a person moves within the fiscal year, but is paid from the same account
combination, Home_School will retain its original values for the fiscal
year. Home_School codes in the Personnel/Payroll and related systems were
converted to Home_School_Ctr codes on July 16, 1999. All records after that
date will have null values for Home_School; Home_School_Ctr should be used
in its place.
Example: 54 (School of Medicine)
Values:
Refer to the DWADMIN.ORG_OLD_TO_NEW table for values.
|
HOME_SCHOOL_CTR
Indexed - yes
Format - char (2)
May be null? yes
|
A 2-digit number used to identify the school or center that
owns the employee's record and is responsible for its maintenance. Since
there is only one record per person per account per fiscal year, although
payment totals are updated, Home_School_Ctr is only loaded once. For example,
if a person moves within the fiscal year, but is paid from the same account
combination, Home_School_Ctr will retain its original values for the fiscal
year. The code set is from the University's General Ledger, and has been
in use since July 1, 1996.
Example: 40 (School of Medicine)
Values:
Refer to the DWADMIN.ORG_CODES table, for values where
Home_School_Ctr = Center_Code.
|
JOB_CLASS
Indexed - yes
Format - char (6)
May be null? yes
|
The 6-digit code indicating the job for which the payment
was made. Key to the job classification table where the job attributes are
listed. Refer to Job_Title in the JOB_CLASS or JOB_CLASS_GENERAL tables
to find the title which currently corresponds to the Job_Class.
Since there is only one record per person per account per fiscal year, although
payment totals are updated, Job_Class is only loaded once. For example,
if a person changes jobs within a fiscal year, but is paid from the same account
combination, Job_Class will retain its original values for the fiscal
year.
As a result
of the University's Classification Redesign Project, a new job classification
system for staff positions was developed in 1998. Job classes in the online
Payroll system and the Data Warehouse were converted to this new system
over April 8 - 9, 1998. For jobs that were reclassified, records before
this date will contain the old class, and records after this date will reflect
the new scheme. Some classes were reused, however (and only the attributes
now used for those classes are available). Faculty classes were unaffected
by this conversion.
Example: 226010 (Associate Professor C-E)
Values:
Refer to the DWADMIN.JOB_CLASS table for values.
|
LAST_EXTRACT_DATE
Indexed - no
Format - date (7)
May be null? yes
|
The date the EMPLOYEE_PAYMENT_SUMMARY record was extracted
from the Payroll system and loaded into the Warehouse. |
PENN_ID
Indexed - no
Format - char (8)
May be null? yes
|
The 8-digit identification number assigned to an individual by Penn Community system. For example: 77777777. No two persons have the same Penn ID. Note that Penn IDs created in and assigned by Penn Community begin at 10000000. Within the Data Warehouse, the numeric range from 00000000-00999999 is used for individuals who do not yet have a Penn ID in Penn Community, to allow for reliable joins between tables using the PENN_ID column. When a Penn ID appears for the individual appear in Penn Community, it will replace the assigned value throughout the Data Warehouse.
|
POSTED_COA_ACCOUNT
Indexed - yes
Format - char (26)
May be null? no
|
The 26-digit account number from the present General Ledger
accounting structure (in use at Penn since July 1, 1996) indicating the
source of the payment to the employee. The Payroll system was rewritten
to accept the 26-digit account code combination in place of legacy 9-digit
account numbers for fiscal year 1999. Effective June 28, 1998, all Payroll
transansactions that require an account are completed using the 26-digit
account code combination. For records prior to fiscal year 1999, this data
element contains the account number that was returned by the GL mapper utility,
given the Requested_Account. In cases where the Requested_Account cannot
be converted, Posted_COA_Account is a suspense account, using the CNAC and
Org that do convert - or, if they do not convert, the CNAC and Org are based
on the Home_Dept. Suspense Accounts have 9501 as the value for Posted_COA_Object.
In cases where the subcode portion of the Requested_Account cannot be translated
to an Object code, OBJT will be used as the Object code. Example: 01111011000000OBJT00000000,
where OBJT indicates that there is not an object code mapping for the requested
subcode portion of the Requested_Account.
The Posted_COA_Account consists of seven segments:
Posted_COA_CNAC
Posted_COA_Org
Posted_COA_BC
Posted_COA_Fund
Posted_COA_Object
Posted_COA_Program
Posted_COA_Center_Ref
See also the definitions for Posted_COA_CNAC, Posted_COA_Org, Posted_COA_BC,
Posted_COA_Fund, Posted_COA_Object, Posted_COA_Program, and Posted_COA_Center_Ref.
|
POSTED_COA_BC
Indexed - no
Format - char (1)
May be null? yes
|
The budgetary control character that represents the level
at which funds availability checking occurs for the salary expense. Posted_COA_BC
is the third segment of the Posted_COA_Account.
Example: 1 (CNAC/ORG/FUND Year-To-Date)
Values:
0 Project-To-Date for capital projects
1 CNAC/ORG/FUND Year-To-Date
2 CNAC/ORG/FUND/CREF Year-To-Date
4 CNAC/ORG/FUND/CREF Project-to-Date
|
POSTED_COA_CENTER_REF
Indexed - yes
Format - char (4)
May be null? yes
|
The Center Reference Code. A 4-character identifier uniquely
defined by each School or Center. Posted_COA_Center_Ref is used to record
information that is important to a school or center but is inappropriate
for any other segment of the Posted_COA_Account. The value of the Posted_COA_Center_Ref
is unique within a school or center. Posted_COA_Center_Ref is the seventh
and last segment of the Posted_COA_Account.
Examples (for center 02): 4045 (Graduate Programs); 4091 (SAS Newsletter)
Values:
Refer to the DWADMIN.CENTER_REF_CODES table for values.
|
POSTED_COA_CNAC
Indexed - yes
Format - char (3)
May be null? yes
|
The 3-character Center Net Asset Class. The first two positions
of the Posted_COA_CNAC identify the school or center. The last position
identifies the Net Asset Class: 0 (Unrestricted); 1 (Temporarily Restricted);
2 (Permanently Restricted). Posted_COA_CNAC is the first segment of the
Posted_COA_Account.
Examples: 880 (Medical School, Unrestricted); 921 (Human Relations, Temporarily
Restricted)
Values:
Refer to the DWADMIN.CNAC_CODES table for values.
|
POSTED_COA_FUND
Indexed - yes
Format - char (6)
May be null? yes
|
The 6-character fund code. A fund is the unique identifier
for a specific set of financial resources that needs tracking or management.
Posted_COA_Fund is the fourth segment of the Posted_COA_Account. If your
organization is the Responsible_Org for the fund (even if it is not the
Posted_COA_Org, the Home_Dept_Org, or the Job_Dept_Org) you will have access
to the record.
Examples: 000000 (General Unrestricted Fund); 010201 (SAS: GEN FUND 1)
Values:
Refer to the DWADMIN.FUND_CODES table for values.
|
POSTED_COA_OBJECT
Indexed - yes
Format - char (4)
May be null? yes
|
The 4-character Object Code that identifies the asset, liability,
revenue, or expense. Posted_COA_Object is the fifth segment of the Posted_COA_Account.
The Payroll system was rewritten to accept that 26-digit account code combination
in place of legacy 9-digit account numbers for fiscal year 1999. Effective
June 28, 1998, all Payroll transactions that require an account are completed
using the 26-digit account code combination. For records prior to fiscal
year 1999, in cases where the Requested_Account could not be converted,
Posted_COA_Account is a suspense account, and 9501 is the value for the
Posted_COA_Object. In cases where the subcode section of the Requested_Account
could not be translated to an Object_Code, OBJT will be the value for Posted_COA_Object.
Examples: 5220 EXTERNAL OFFICE SUPPLIES); 1149 (CASH SUSPENSE)
Values:
Refer to the DWADMIN.OBJECT_CODES table for values.
|
POSTED_COA_ORG
Indexed - yes
Format - char (4)
May be null? yes
|
The 4-character code identifying the Organization. This is
a subdivision of the University created for management purposes. An Organization
belongs to only one responsibility center, and its Organization code is
unique. That is, no two Organizations will have the same values for Posted_COA_Org.
Posted_COA_Org is the second segment of the Posted_COA_Account.
Examples: 0702 (Wharton Finance); 0705 (Wharton Legal Studies)
Values:
Refer to the DWADMIN.ORG_CODES table for values.
|
POSTED_COA_PROGRAM
Indexed - yes
Format - char (4)
May be null? yes
|
The 4-character code indicating the program. This is an activity
or work process commonly defined across the University for tracking a program's
activity across Schools and Centers (or across organizations within a school
or center). Posted_COA_Program is the sixth segment of the Posted_COA_Account.
Examples: 7311 (ALUMNI RELATIONS); 0001 (DISCRETIONARY)
Values:
Refer to the DWADMIN.PROGRAM_CODES table for values.
|
RESPONSIBLE_ORG
Indexed - yes
Format - char (4)
May be null? yes
|
The 4-character code for the organization responsible for
managing the Posted_COA_Fund. Many organizations may use the same fund,
but only one organization -- the Responsible_Org -- is accountable for managing
the fund. Those who are authorized to access records for the Responsible_Org
for the fund may access all records for the fund, regardless of the value
of the Posted_COA_Org in the Posted_COA_Account for the record.
Values:
Refer to the DWADMIN.ORG_CODES table for values.
|
SSN
Indexed - yes
Format - char (9)
May be null? no
|
The 9-digit Social Security number of the employee. A Social
Security number is a unique number assigned to an individual by the federal
Social Security Administration.
Values in this column will only be displayed to individuals with access to employee SSN data; all other users will retrieve nulls in this column.
|
