Penn Computing

University of Pennsylvania
Penn Computing << go backback
DIRECT_DEPOSIT Table   Cross-Collection Home   Data Warehouse Home

DIRECT_DEPOSIT Table - Data Element Index

Select a data element to view its definition and its indexed, format, and null values.



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


DIRECT_DEPOSIT Table   Cross-Collection Home   Data Warehouse Home

Questions about this page? Email us at da-staff@isc.upenn.edu

Information Systems and Computing
University of Pennsylvania
Information Systems and Computing, University of Pennsylvania