Data element |
Definition |
COMP_PAY_PERSON_HOME_CENTER
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. 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_Center = Center_Code.
|
COMP_PAY_PERSON_HOME_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. 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.
|
COMP_PAY_PERSON_ID
Indexed - yes
Format - number (22)
May be null? no
|
Unique system identifier for the person to be paid by this particular pay request. |
COMP_PAY_PERSON_PENN_ID
Indexed - yes
Format - varchar2 (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.
|
COMP_PAY_REQUEST_ID
Indexed - yes
Format - number (22)
May be null? no
|
Uniquely identifies an Additional Pay request in the PennWorks system. |
COMP_PAY_STAGE_ID
Indexed - yes
Format - number (22)
May be null? no
|
Uniquely identifies a record in the COMP_PAY_STAGING table. |
COMP_PERSON_ID
Indexed - yes
Format - number (12)
May be null? no
|
The unique ID for an employee in the PennWorks application. This number is not used in other data collections, and should not be used for reporting. |
CREATED_BY
Indexed - no
Format - varchar2 (12)
May be null? yes
|
The Penn ID of the PennWorks user who created the record in the PennWorks Additional Pay module.
|
CREATION_DATE
Indexed - no
Format - date (7)
May be null? yes
|
The date on which the record was created in the PennWorks Additional Pay module.
|
EARNINGS_TYPE
Indexed - yes
Format - char (3)
May be null? yes
|
The 3-character code indicating the type of earnings for the pay request.
Values:
Refer to the DWPAY.PAYROLL_EARNINGS table for values.
|
EXTRACT_DATE
Indexed - no
Format - date (7)
May be null? yes
|
The date on which the COMP_PAY_STAGING record was loaded to the Data Warehouse.
|
JOB_CLASS
Indexed - yes
Format - varchar2 (6)
May be null? yes
|
The 6-digit code indicating the job held by the employee. 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.
Example: 226010 (Associate Professor C-E)
Values:
Refer to the DWADMIN.JOB_CLASS table for values.
|
LAST_UPDATE_DATE
Indexed - no
Format - date (7)
May be null? yes
|
The date on which the record was last updated in the PennWorks Additional Pay module.
|
LAST_UPDATE_TIMESTAMP
Indexed - no
Format - timestamp (6)
May be null? yes
|
The timestamp on which the record was last updated in the PennWorks Additional Pay module.
|
LAST_UPDATED_BY
Indexed - no
Format - varchar2 (12)
May be null? yes
|
The Penn ID of the PennWorks user who last updated the record in the PennWorks Additional Pay module.
|
PAY_DISTRIBUTION_AMOUNT
Indexed - no
Format - number (9,3)
May be null? yes
|
The pay period amount associated with the additional pay distribution. |
PAY_DISTRIBUTION_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. Pay_Distribution_COA_BC is the third segment of the Pay_Distribution_COA_Number.
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
|
PAY_DISTRIBUTION_COA_CNAC
Indexed - yes
Format - char (3)
May be null? yes |
The 3-character Center Net Asset Class. The first two positions of the Pay_Distribution_COA_CNAC identify the school or center. The last position identifies the Net Asset Class: 0 (Unrestricted); 1 (Temporarily Restricted); 2 (Permanently Restricted). Distribution_COA_CNAC is the first segment of the Pay_Distribution_COA_Number.
Examples: 880 (Medical Center, Unrestricted); 921 (Human Resources, Temporarily Restricted)
Values:
Refer to the DWADMIN.CNAC_CODES table for values.
|
PAY_DISTRIBUTION_COA_CREF
Indexed - yes
Format - char (4)
May be null? yes |
The Center Reference Code. This is a 4-character identifier uniquely defined by each School or Center. Pay_Distribution_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 Pay_Distribution_COA_Account. The value of the Pay_Distribution_COA_Center_Ref is unique within a school or center. Pay_Distribution_COA_Center_Ref is the seventh and last segment of the Pay_Distribution_COA_Number.
Examples (for center 02): 4045 (Graduate Programs); 4091 (SAS Newsletter)
Values:
Refer to the DWADMIN.CENTER_REF_CODES table for values.
|
PAY_DISTRIBUTION_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. Pay_Distribution_COA_Fund is the fourth segment of the Pay_Distribution_COA_Number. If your organization is the Responsible_Org for the fund (even if it is not the Pay_Distribution_COA_Org, the Home_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.
|
PAY_DISTRIBUTION_COA_NUMBER
Indexed - yes
Format - char (9)
May be null? yes |
The 26-digit account number indicating the
funding source of this additional pay distribution for the employee. The Pay_Distribution_COA_Account
consists of seven segments:
Pay_Distribution_COA_CNAC
Pay_Distribution_COA_Org
Pay_Distribution_COA_BC
Pay_Distribution_COA_Fund
Pay_Distribution_COA_Object
Pay_Distribution_COA_Program
Pay_Distribution_COA_CREF
See also the definitions for Pay_Distribution_COA_CNAC, Pay_Distribution_COA_Org, Pay_Distribution_COA_BC, Pay_Distribution_COA_Fund, Pay_Distribution_COA_Object, Pay_Distribution_COA_Program, and Pay_Distribution_COA_CREF.
|
PAY_DISTRIBUTION_COA_OBJECT
Indexed - yes
Format - char (4)
May be null? yes
|
The 4-character Object Code. Identifies the asset, liability, revenue, or expense. Pay_Distribution_COA_Object is the fifth segment of the Pay_Distribution_COA_Number.
Examples: 5220 (EXTERNAL OFFICE SUPPLIES); 1149 (CASH SUSPENSE).
Values:
Refer to the DWADMIN.OBJECT_CODES table for values.
|
PAY_DISTRIBUTION_COA_ORG
Indexed - yes
Format - char (4)
May be null? yes
|
The 4-character code that identifies the Organization. An Organization 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 Pay_Distribution_COA_Org. Pay_Distribution_COA_Org is the second segment of the Pay_Distribution_COA_Number
Examples: 0702 (Wharton Finance); 0705 (Wharton Legal Studies)
Values:
Refer to the DWADMIN.ORG_CODES table for values.
|
PAY_DISTRIBUTION_COA_PROGRAM
Indexed - yes
Format - char (4)
May be null? yes
|
The 4-character program code. A program 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). Pay_Distribution_COA_Program is the sixth segment of the Pay_Distribution_COA_Number.
Examples: 7311 (Alumni Relations); 0001 (Discretionary)
Values:
Refer to the DWADMIN.PROGRAM_CODES Table for values.
|
PAY_DISTRIBUTION_COA_RESP_ORG
Indexed - yes
Format - char (4)
May be null? yes
|
The 4-character code for the organization responsible for managing the Pay_Distribution_COA_Fund. Many organizations may use the same fund, but only one organization -- the Responsible Organziation-- is accountable for managing the fund. Those who are authorized to access records for the Pay_Distribution_COA_Resp_ORG for the fund may access all records for the fund, regardless of the value of the Pay_Distribution_COA_Org in the Pay_Distribution_COA_Number for the record.
Values:
Refer to the DWADMIN.ORG_CODES table for values.
|
PAY_PERIOD_END_DATE
Indexed - no
Format - date (7)
May be null? yes
|
The end date of the pay period during which this distribution will be or was paid.
|
PAY_RUN_CYCLE
Indexed - yes
Format - varchar2 (2)
May be null? yes
|
The pay cycle of the payroll period in which the payment was made (e.g., W1 = weekly, M1 = monthly).
|
PAY_RUN_END_DATE
Indexed - no
Format - date (7)
May be null? yes
|
The end date of the payroll period in which the payment was made.
|
SUBMITTED_DATE
Indexed - no
Format - date (7)
May be null? yes
|
The date that this record was submitted to the mainframe Payroll system for processing.
|
WEEKLY_HOURLY_RATE
Indexed - no
Format - number (22)
May be null? yes
|
For weekly employees, the hourly rate associated with the pay request.
|
WEEKLY_HOURS_WORKED
Indexed - no
Format - number (22)
May be null? yes |
For weekly employees, the number of hours worked for for the pay request.
|