| Data element |
Definition |
ACCT_CREATED
Indexed - no
Format - date
May be null? yes |
The date the account was created.
Source:
162: null
369: ACCT-EST-DATE
44: ACTIV-DATE |
ACCT_NUMBER
Indexed - no
Format - varchar2(20)
May be null? yes |
The full direct deposit account number.
Source:
162: XDBS-DISB-ACCT-NO
369: CHA-ACCT-NUMBER
44: BANK-ACCT-NUM |
ACCT_NUMBER4
Indexed - yes
Format - varchar2(4)
May be null? no |
The last 4 digits of the direct deposit account number.
Source:
162: XDBS-DISB-ACCT-NO (last 4 digits)
369: CHA-ACCT-NUMBER (last 4 digits)
44: BANK-ACCT-NUM (last 4 digits) |
ACCT_TYPE
Indexed - no
Format - varchar2(1)
May be null? yes |
The type of direct deposit account (C: Checking; S: Savings). All PayCards are checking accounts and will always be 'C'.
Source:
162: XDBS-DISB-ACCT-TYPE
369: DISTRIBUTION-TYPE
44: BANK-ACCT-TYPE |
ALTERNATE_SSN
Indexed - no
Format - varchar2(9)
May be null? yes |
Used only for PayCard, where PATS SSN differs from Payroll or SRS SSN. |
APPROVED
Indexed - no
Format - varchar2(1)
May be null? no |
Indicates whether the account has been approved to be used. PayCard accounts are not prenoted will always be set to 'T'.
Source:
162: XDBS-ACH-APPRV-IND if 'A' then 'T' else 'F'
369: always 'T'
44: if prenote_id = 'Y' then 'F' else 'T'
|
DD_TYPE
Indexed - yes
Format - varchar2(7)
May be null? no |
The type of direct deposit (Payroll, Student, PayCard).
Source:
EDBB-FILE (162): Payroll
PBP-PAYCARD (369): PayCard
SFS-DDR-MASTER (44): Student |
LAST_UPDATE_USER
Indexed - no
Format - varchar2(8)
May be null? yes |
The user who last updated the record
Source:
162: null
369: LAST-UPDATED-BY
44: DDR-UPDATE-USER |
LAST_UPDATED_TATE
Indexed - no
Format - date
May be null? yes |
The date the record was last updated
Source:
162: null
369: LAST-UPDATE-DATE
44: DDR-UPDATE-DATE |
PATS_EMPL_ID
Indexed - no
Format - varchar2(20)
May be null? yes |
Used for PayCard only. |
PENN_ID
Indexed - yes
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.
Source: Determined by mapping SSN to Penn_ID
|
PRENOTE_DATE
Indexed - yes
Format - date
May be null? yes |
The date the account was sent to the bank for prenoting .
Source:
162: XDBS-ACH-PRENOTE-DATE
369: null
44: null |
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.
Source:
162: XDBS-EMPL-ID
369: PATS-SSN
44: SID |
TRANSIT_ID
Indexed - no
Format - char (9)
May be null? yes |
The transit ID of the account.
Source:
162: XDBS-DISB-INSTITUTION
369: CHA-ROUTING-NUMBER
44: BANK-ROUTING-NUM |
