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

TABLE: HR.PAY_ZA_TEMP_BRANCH_DETAILS

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


PAY_ZA_TEMP_BRANCH_DETAILS is a temporary table that holds Bank and Branch information used to verify Bank account numbers, used in the population of PAY_ZA_BRANCH_CDV_DETAILS.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Primary Key: PAY_ZA_TEMP_BRANCH_DETAI_PK
  1. ColumnBRANCH_CODE
Indexes
Index Type Uniqueness Tablespace Column
PAY_ZA_TEMP_BRANCH_DETAI_PK NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnBRANCH_CODE
Columns
Name Datatype Length Mandatory Comments
RECORD_IND NUMBER (2)
Type of record
BRANCH_CODE VARCHAR2 (6) Yes Branch Code
SSV_ALLOWED NUMBER (1) Yes Sub-service allowed indicator
ONE_DAY_SS NUMBER (1)
One day sub-service
TWO_DAY_SS NUMBER (1)
Two day sub-service
FIVE_DAY_SS NUMBER (1)
Five day sub-service
STREAM_CODE NUMBER (2) Yes Stream Code
BRANCH_NAME VARCHAR2 (30) Yes Branch Name
STREET_ADDRESS_LINE_1 VARCHAR2 (48)
Address Details
STREET_ADDRESS_LINE_2 VARCHAR2 (48)
Address Details
PO_BOX_NUMBER VARCHAR2 (35)
Address Details
PO_BOX_POST_OFFICE VARCHAR2 (20)
Address Details
POSTAL_CODE NUMBER (6)
Address Details
ACCOUNT_TYPE_1 NUMBER (1)
Type of account
MODULUS_1 NUMBER (2)
Modulus factor
FUDGE_FACTOR_1 NUMBER (2)
Factor added to check sum calculation
CDV_WEIGHTINGS_1 VARCHAR2 (22)
Validation weighting
EXCEPTION_CODE_1 VARCHAR2 (2)
Additional Validation
ACCOUNT_IND_1 VARCHAR2 (1)
Account Indicator
ACCOUNT_TYPE_2 NUMBER (1)
Type of account
MODULUS_2 NUMBER (2)
Modulus factor
FUDGE_FACTOR_2 NUMBER (2)
Factor added to check sum calculation
CDV_WEIGHTINGS_2 VARCHAR2 (22)
Validation weighting
EXCEPTION_CODE_2 VARCHAR2 (2)
Additional Validation
ACCOUNT_IND_2 VARCHAR2 (1)
Account Indicator
ACCOUNT_TYPE_3 NUMBER (1)
Type of account
MODULUS_3 NUMBER (2)
Modulus factor
FUDGE_FACTOR_3 NUMBER (2)
Factor added to check sum calculation
CDV_WEIGHTINGS_3 VARCHAR2 (22)
Validation weighting
EXCEPTION_CODE_3 VARCHAR2 (2)
Additional Validation
ACCOUNT_IND_3 VARCHAR2 (1)
Account Indicator
ACCOUNT_TYPE_4 NUMBER (1)
Type of account
MODULUS_4 NUMBER (2)
Modulus factor
FUDGE_FACTOR_4 NUMBER (2)
Factor added to check sum calculation
CDV_WEIGHTINGS_4 VARCHAR2 (22)
Validation weighting
EXCEPTION_CODE_4 VARCHAR2 (2)
Additional Validation
ACCOUNT_IND_4 VARCHAR2 (1)
Account Indicator
ACCOUNT_TYPE_5 NUMBER (1)
Type of account
MODULUS_5 NUMBER (2)
Modulus factor
FUDGE_FACTOR_5 NUMBER (2)
Factor added to check sum calculation
CDV_WEIGHTINGS_5 VARCHAR2 (22)
Validation weighting
EXCEPTION_CODE_5 VARCHAR2 (2)
Additional Validation
ACCOUNT_IND_5 VARCHAR2 (1)
Account Indicator
ACCOUNT_TYPE_6 NUMBER (1)
Type of account
MODULUS_6 NUMBER (2)
Modulus factor
FUDGE_FACTOR_6 NUMBER (2)
Factor added to check sum calculation
CDV_WEIGHTINGS_6 VARCHAR2 (22)
Validation weighting
EXCEPTION_CODE_6 VARCHAR2 (2)
Additional Validation
ACCOUNT_IND_6 VARCHAR2 (1)
Account Indicator
ACCOUNT_TYPE_7 NUMBER (1)
Type of account
MODULUS_7 NUMBER (2)
Modulus factor
FUDGE_FACTOR_7 NUMBER (2)
Factor added to check sum calculation
CDV_WEIGHTINGS_7 VARCHAR2 (22)
Validation weighting
EXCEPTION_CODE_7 VARCHAR2 (2)
Additional Validation
ACCOUNT_IND_7 VARCHAR2 (1)
Account Indicator
ACCOUNT_TYPE_8 NUMBER (1)
Type of account
MODULUS_8 NUMBER (2)
Modulus factor
FUDGE_FACTOR_8 NUMBER (2)
Factor added to check sum calculation
CDV_WEIGHTINGS_8 VARCHAR2 (22)
Validation weighting
EXCEPTION_CODE_8 VARCHAR2 (2)
Additional Validation
ACCOUNT_IND_8 VARCHAR2 (1)
Account Indicator
ACCOUNT_TYPE_9 NUMBER (1)
Type of account
MODULUS_9 NUMBER (2)
Modulus factor
FUDGE_FACTOR_9 NUMBER (2)
Factor added to check sum calculation
CDV_WEIGHTINGS_9 VARCHAR2 (22)
Validation weighting
EXCEPTION_CODE_9 VARCHAR2 (2)
Additional Validation
ACCOUNT_IND_9 VARCHAR2 (1)
Account Indicator
TELEPHONE_NUMBER VARCHAR2 (14)
Contact Details
DIALING_CODE VARCHAR2 (20)
Contact Details
TELEX1 VARCHAR2 (20)
Contact Details
TELEX2 VARCHAR2 (20)
Contact Details
DELETION_DATE NUMBER (6)
Deletion Date of Information
Query Text

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


SELECT RECORD_IND
,      BRANCH_CODE
,      SSV_ALLOWED
,      ONE_DAY_SS
,      TWO_DAY_SS
,      FIVE_DAY_SS
,      STREAM_CODE
,      BRANCH_NAME
,      STREET_ADDRESS_LINE_1
,      STREET_ADDRESS_LINE_2
,      PO_BOX_NUMBER
,      PO_BOX_POST_OFFICE
,      POSTAL_CODE
,      ACCOUNT_TYPE_1
,      MODULUS_1
,      FUDGE_FACTOR_1
,      CDV_WEIGHTINGS_1
,      EXCEPTION_CODE_1
,      ACCOUNT_IND_1
,      ACCOUNT_TYPE_2
,      MODULUS_2
,      FUDGE_FACTOR_2
,      CDV_WEIGHTINGS_2
,      EXCEPTION_CODE_2
,      ACCOUNT_IND_2
,      ACCOUNT_TYPE_3
,      MODULUS_3
,      FUDGE_FACTOR_3
,      CDV_WEIGHTINGS_3
,      EXCEPTION_CODE_3
,      ACCOUNT_IND_3
,      ACCOUNT_TYPE_4
,      MODULUS_4
,      FUDGE_FACTOR_4
,      CDV_WEIGHTINGS_4
,      EXCEPTION_CODE_4
,      ACCOUNT_IND_4
,      ACCOUNT_TYPE_5
,      MODULUS_5
,      FUDGE_FACTOR_5
,      CDV_WEIGHTINGS_5
,      EXCEPTION_CODE_5
,      ACCOUNT_IND_5
,      ACCOUNT_TYPE_6
,      MODULUS_6
,      FUDGE_FACTOR_6
,      CDV_WEIGHTINGS_6
,      EXCEPTION_CODE_6
,      ACCOUNT_IND_6
,      ACCOUNT_TYPE_7
,      MODULUS_7
,      FUDGE_FACTOR_7
,      CDV_WEIGHTINGS_7
,      EXCEPTION_CODE_7
,      ACCOUNT_IND_7
,      ACCOUNT_TYPE_8
,      MODULUS_8
,      FUDGE_FACTOR_8
,      CDV_WEIGHTINGS_8
,      EXCEPTION_CODE_8
,      ACCOUNT_IND_8
,      ACCOUNT_TYPE_9
,      MODULUS_9
,      FUDGE_FACTOR_9
,      CDV_WEIGHTINGS_9
,      EXCEPTION_CODE_9
,      ACCOUNT_IND_9
,      TELEPHONE_NUMBER
,      DIALING_CODE
,      TELEX1
,      TELEX2
,      DELETION_DATE
FROM HR.PAY_ZA_TEMP_BRANCH_DETAILS;

Dependencies

[top of page]

HR.PAY_ZA_TEMP_BRANCH_DETAILS does not reference any database object

HR.PAY_ZA_TEMP_BRANCH_DETAILS is referenced by following:

SchemaHR
ViewPAY_ZA_TEMP_BRANCH_DETAILS#