| Data element |
Definition |
COMP_ATTACHMENT_GROUP_ID
Indexed - yes
Format - number (22)
May be null? yes
|
Uniquely identifies the group of attachments (if any exist) for the person to be paid for this pay request. |
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 the associated Additional Pay request in the PennWorks system. |
| 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.
|
EXTRACT_DATE
Indexed - no
Format - date (7)
May be null? yes
|
The date on which the COMP_PAY_PERSON record was loaded to the Data Warehouse.
|
|
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.
|
PERSON_PAY_REQ_REASON
Indexed - no
Format - varchar2 (1000)
May be null? yes |
A reason that the person is associated with this pay request. |
SUPERVISOR_PENN_ID
Indexed - no
Format - varchar2 (8)
May be null? yes
|
For employees paid by an Additional Pay Prework request, the Penn ID of the supervisor of this pre-work payee.
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. |
