VIEW: HR.PAY_ZA_TEMP_BRANCH_DETAILS#

Source

View Text - Preformatted

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

View Text - HTML Formatted

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