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

TABLE: HR.PAY_ZA_BRANCH_CDV_DETAILS

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


PAY_ZA_BRANCH_CDV_DETAILS stores Bank and Branch information used to verify Bank account numbers.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Primary Key: PAY_ZA_BRANCH_CDV_DETAIL_PK
  1. ColumnBRANCH_CODE
Indexes
Index Type Uniqueness Tablespace Column
PAY_ZA_BRANCH_CDV_DETAIL_PK NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnBRANCH_CODE
Columns
Name Datatype Length Mandatory Comments
BRANCH_CODE VARCHAR2 (6) Yes Branch Code
SSV_ALLOWED NUMBER (1) Yes Sub-service allowed (Y/N)
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
BANK_NAME VARCHAR2 (40)
Bank Name
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
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
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
,      SSV_ALLOWED
,      ONE_DAY_SS
,      TWO_DAY_SS
,      FIVE_DAY_SS
,      STREAM_CODE
,      BANK_NAME
,      BRANCH_NAME
,      STREET_ADDRESS_LINE_1
,      STREET_ADDRESS_LINE_2
,      PO_BOX_NUMBER
,      PO_BOX_POST_OFFICE
,      POSTAL_CODE
,      TELEPHONE_NUMBER
,      DIALING_CODE
,      TELEX1
,      TELEX2
,      DELETION_DATE
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CREATED_BY
,      CREATION_DATE
FROM HR.PAY_ZA_BRANCH_CDV_DETAILS;

Dependencies

[top of page]

HR.PAY_ZA_BRANCH_CDV_DETAILS does not reference any database object

HR.PAY_ZA_BRANCH_CDV_DETAILS is referenced by following:

SchemaHR
ViewPAY_ZA_BRANCH_CDV_DETAILS#