DBA Data[Home] [Help] [Dependency Information]

VIEW: APPS.HR_CERIDIAN_EFT_V

Object Details
Object Name: HR_CERIDIAN_EFT_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewPER.HR_CERIDIAN_EFT_V
Subobject Name:
Status: VALID

View Type

A public view which may be useful for custom reporting or other data
requirements.


This view returns NACHA personal payment methods. It is used to interface direct deposit information to Ceridian's Source 100 and Encore payroll systems.


[View Source]

Columns
Name Datatype Length Mandatory Comments
EMPLOYEE_NUMBER VARCHAR2 (30)
Employee number
COMPANY VARCHAR2 (240) Yes GRE name
BANK_NAME VARCHAR2 (150)
Bank name
BANK_BRANCH VARCHAR2 (150)
Bank branch
ACCOUNT_NUMBER VARCHAR2 (150)
Account number
ACCOUNT_TYPE VARCHAR2 (150)
Account type
TRANSIT_NUMBER VARCHAR2 (150)
Transit number
ACCOUNT_ID VARCHAR2 (1)
Ceridian account ID derived from payment method priority
PRIORITY NUMBER (15)
Payment method priority
AMOUNT NUMBER

Dollar amount allocated to this payment method
ACTIVE_FLAG VARCHAR2 (1)
Indicates if this payment method is active
BUSINESS_GROUP_ID NUMBER (15) Yes Business Group ID
PERSON_ID NUMBER (10) Yes Person ID
LAST_UPDATE_DATE DATE

Date on which personal payment method information was last changed
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT EMPLOYEE_NUMBER
,      COMPANY
,      BANK_NAME
,      BANK_BRANCH
,      ACCOUNT_NUMBER
,      ACCOUNT_TYPE
,      TRANSIT_NUMBER
,      ACCOUNT_ID
,      PRIORITY
,      AMOUNT
,      ACTIVE_FLAG
,      BUSINESS_GROUP_ID
,      PERSON_ID
,      LAST_UPDATE_DATE
FROM APPS.HR_CERIDIAN_EFT_V;

Dependencies

[top of page]

APPS.HR_CERIDIAN_EFT_V references the following:

SchemaAPPS
SynonymHR_ALL_ORGANIZATION_UNITS
SynonymHR_SOFT_CODING_KEYFLEX
SynonymPAY_EXTERNAL_ACCOUNTS
SynonymPAY_ORG_PAYMENT_METHODS_F
SynonymPAY_PAYMENT_TYPES
SynonymPAY_PERSONAL_PAYMENT_METHODS_F
SynonymPER_ALL_ASSIGNMENTS_F
SynonymPER_ALL_PEOPLE_F

APPS.HR_CERIDIAN_EFT_V is not referenced by any database object