Skip to content

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

TABLE: HR.PAY_ZA_CDV_PARAMETERS

Object Details
Object Name: PAY_ZA_CDV_PARAMETERS
Object Type: TABLE
Owner: HR
FND Design Data: TablePAY.PAY_ZA_CDV_PARAMETERS
Subobject Name:
Status: VALID


PAY_ZA_CDV_PARAMETERS holds information needed to perform the CDV on bank account numbers.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Columns
Name Datatype Length Mandatory Comments
BRANCH_CODE VARCHAR2 (6) Yes Branch Code
ACCOUNT_TYPE NUMBER (1) Yes Type of account
MODULUS NUMBER (2)
Modulus factor
FUDGE_FACTOR NUMBER (2)
Factor added to check sum calculation
CDV_WEIGHTING1 NUMBER (2)
Validation weighting
CDV_WEIGHTING2 NUMBER (2)
Validation weighting
CDV_WEIGHTING3 NUMBER (2)
Validation weighting
CDV_WEIGHTING4 NUMBER (2)
Validation weighting
CDV_WEIGHTING5 NUMBER (2)
Validation weighting
CDV_WEIGHTING6 NUMBER (2)
Validation weighting
CDV_WEIGHTING7 NUMBER (2)
Validation weighting
CDV_WEIGHTING8 NUMBER (2)
Validation weighting
CDV_WEIGHTING9 NUMBER (2)
Validation weighting
CDV_WEIGHTING10 NUMBER (2)
Validation weighting
CDV_WEIGHTING11 NUMBER (2)
Validation weighting
EXCEPTION_CODE VARCHAR2 (2)
Additional validation
ACCOUNT_INDICATOR VARCHAR2 (1)
Account indicator
LAST_UPDATE_DATE DATE

Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY NUMBER (15)
Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_LOGIN NUMBER (15)
Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
CREATED_BY NUMBER (15)
Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
CREATION_DATE DATE

Standard who column - date when this row was created.
Query Text

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


SELECT BRANCH_CODE
,      ACCOUNT_TYPE
,      MODULUS
,      FUDGE_FACTOR
,      CDV_WEIGHTING1
,      CDV_WEIGHTING2
,      CDV_WEIGHTING3
,      CDV_WEIGHTING4
,      CDV_WEIGHTING5
,      CDV_WEIGHTING6
,      CDV_WEIGHTING7
,      CDV_WEIGHTING8
,      CDV_WEIGHTING9
,      CDV_WEIGHTING10
,      CDV_WEIGHTING11
,      EXCEPTION_CODE
,      ACCOUNT_INDICATOR
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CREATED_BY
,      CREATION_DATE
FROM HR.PAY_ZA_CDV_PARAMETERS;

Dependencies

[top of page]

HR.PAY_ZA_CDV_PARAMETERS does not reference any database object

HR.PAY_ZA_CDV_PARAMETERS is referenced by following:

SchemaHR
ViewPAY_ZA_CDV_PARAMETERS#