GPAU_KYETXML_VW(SQL View) |
Index Back |
---|---|
SuperStream - Key Entity TableThis table stores the Key entity information used in SuperStream reporting. |
SELECT %Sql(GPAU_FUNC_RTRIM,A.CAL_RUN_ID) %Concat %Sql(GPAU_FUNC_RTRIM,A.PAY_ENTITY) , A.GPAU_SMART_KEY , A.GPAU_LODGEMENT_REF , A.CAL_RUN_ID , A.PAY_ENTITY , A.RECIPIENT_ID , A.GPAU_SENDERID , A.GPAU_RECEIVERID , A.GPAU_PAYERID , A.GPAU_PAYEEID , A.GP_PAYGROUP , A.GPAU_SENDER_ABN , A.GPAU_SENDER_NAME , A.GPAU_CON_FAMILY_NM , %Substring(A.GPAU_CONTACT_GV_NM,1,40) , %Substring(A.DISPLAY_NAME,1,40) , A.JOBCODE_DESCR , A.GPAU_EMAIL_ADDR , A.GPAU_PHONE_SERVICE , %Substring(A.PHONE,1,16) , A.GPAU_SENDER_URL , A.GPAU_ERROR_ENABLED , A.GPAU_RECEIVER_ABN , A.GPAU_RECEIVER_NAME , A.GPAU_PAYER_ABN , A.GPAU_PAYER_NM , A.GPAU_BRANCH_EC_CD , A.GPAU_ACCOUNT_EC_ID , A.GPAU_ACCOUNT_NAME , A.GPAU_BRANCH_NAME , A.GPAU_BANK_NM , A.GPAU_PAYEE_ABN , A.GPAU_PYMT_MTHD , %Coalesce(A.DEBIT_DT,%datenull) , A.GPAU_CRN , A.GPAU_BILLER_CODE , A.PAYMENT_AMT , A.BRANCH_EC_CD , A.ACCOUNT_EC_ID , A.ACCOUNT_NAME , A.BANK_NM , A.GPAU_BRANCH_NM , A.GPAU_TARGTPRODID , A.GPAU_TARGET_URL , A.GPAU_ER_ABN , A.GPAU_ER_NAME , A.GPAU_SUPER_EMPLID , A.LOCATION_DESCR , %Coalesce(C.PRD_BGN_DT,%datenull) , %Coalesce(C.PRD_END_DT,%datenull) FROM PS_GPAU_KYENT_TBL A , PS_GP_CAL_RUN_DTL C WHERE C.CAL_RUN_ID = A.CAL_RUN_ID AND C.PAY_ENTITY = A.PAY_ENTITY AND C.GP_PAYGROUP = A.GP_PAYGROUP AND C.CAL_SEQ_NUM = ( SELECT MAX(CAL_SEQ_NUM) FROM PS_GP_CAL_RUN_DTL C1 WHERE C1.CAL_RUN_ID = C.CAL_RUN_ID) |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | GPAU_CALPYENT | Character(30) | VARCHAR2(30) NOT NULL | CAL_RUN_ID + PAY_ENTITY |
2 | GPAU_SMART_KEY | Character(90) | VARCHAR2(90) NOT NULL | Primary Key used in SuperStream reporting |
3 | GPAU_LODGEMENT_REF | Character(50) | VARCHAR2(50) NOT NULL | This field is used in the AE program GPAU_EFT_CMX. |
4 | CAL_RUN_ID | Character(18) | VARCHAR2(18) NOT NULL | Calendar Run Id |
5 | PAY_ENTITY | Character(10) | VARCHAR2(10) NOT NULL | Pay Entity |
6 | RECIPIENT_ID | Character(8) | VARCHAR2(8) NOT NULL | Payment recipient ID |
7 | GPAU_SENDERID | Character(30) | VARCHAR2(30) NOT NULL | GPAUS - Stores the ID of the Sender for SuperEC processing. |
8 | GPAU_RECEIVERID | Character(30) | VARCHAR2(30) NOT NULL | GPAUS - Stores the ID of the Super Fund Administrator that is to receive a SuperEC message file. |
9 | GPAU_PAYERID | Character(9) | VARCHAR2(9) NOT NULL | Payer ID |
10 | GPAU_PAYEEID | Character(20) | VARCHAR2(20) NOT NULL | Payee ID |
11 | GP_PAYGROUP | Character(10) | VARCHAR2(10) NOT NULL | Global Payroll pay group |
12 | GPAU_SENDER_ABN | Character(11) | VARCHAR2(11) NOT NULL | Sender ABN |
13 | GPAU_SENDER_NAME | Character(76) | VARCHAR2(76) NOT NULL | Sender Name |
14 | GPAU_CON_FAMILY_NM | Character(30) | VARCHAR2(30) NOT NULL | Given family name |
15 | GPAU_CONTACT_GV_NM | Character(45) | VARCHAR2(45) NOT NULL | Given contact name |
16 | DISPLAY_NAME | Character(50) | VARCHAR2(50) NOT NULL | Used to display the person's name in the PERS_SRCH_SBP, EMPL_SRCH_SBP and the components that allow a person to be created |
17 | JOBCODE_DESCR | Character(30) | VARCHAR2(30) NOT NULL | Job Code Description |
18 | GPAU_EMAIL_ADDR | Character(76) | VARCHAR2(76) NOT NULL | Supplier E-mail address |
19 | GPAU_PHONE_SERVICE | Character(2) | VARCHAR2(2) NOT NULL | Used in SS Report |
20 | PHONE | Character(24) | VARCHAR2(24) NOT NULL | Telephone |
21 | GPAU_SENDER_URL | Character(254) | VARCHAR2(254) NOT NULL | Sender E-Service Address |
22 | GPAU_ERROR_ENABLED | Character(1) | VARCHAR2(1) NOT NULL | Error handling enabled indicator |
23 | GPAU_RECEIVER_ABN | Character(11) | VARCHAR2(11) NOT NULL | Receiver ABN |
24 | GPAU_RECEIVER_NAME | Character(76) | VARCHAR2(76) NOT NULL | Receiver Name |
25 | GPAU_PAYER_ABN | Character(11) | VARCHAR2(11) NOT NULL | Payer ABN |
26 | GPAU_PAYER_NM | Character(200) | VARCHAR2(200) NOT NULL | Payer Name |
27 | GPAU_BRANCH_EC_CD | Character(17) | VARCHAR2(17) NOT NULL | Branch Code |
28 | GPAU_ACCOUNT_EC_ID | Character(35) | VARCHAR2(35) NOT NULL | Account Number used in banking. |
29 | GPAU_ACCOUNT_NAME | Character(50) | VARCHAR2(50) NOT NULL | Account Name |
30 | GPAU_BRANCH_NAME | Character(30) | VARCHAR2(30) NOT NULL | Bank Branch Name |
31 | GPAU_BANK_NM | Character(40) | VARCHAR2(40) NOT NULL | Bank Name |
32 | GPAU_PAYEE_ABN | Character(11) | VARCHAR2(11) NOT NULL | Payee ABN |
33 | GPAU_PYMT_MTHD | Character(15) | VARCHAR2(15) NOT NULL | Payment Method |
34 | DEBIT_DT | Date(10) | DATE | Debit Date |
35 | GPAU_CRN | Character(20) | VARCHAR2(20) NOT NULL | Customer Reference Number |
36 | GPAU_BILLER_CODE | Character(20) | VARCHAR2(20) NOT NULL | BPAY Biller Code |
37 | PAYMENT_AMT | Number(19,3) | DECIMAL(18,3) NOT NULL | Payment Amount |
38 | BRANCH_EC_CD | Character(17) | VARCHAR2(17) NOT NULL | Bank Branch ID |
39 | ACCOUNT_EC_ID | Character(35) | VARCHAR2(35) NOT NULL | Account Number used in banking. |
40 | ACCOUNT_NAME | Character(50) | VARCHAR2(50) NOT NULL | Account Name |
41 | BANK_NM | Character(40) | VARCHAR2(40) NOT NULL | Bank Name |
42 | GPAU_BRANCH_NM | Character(30) | VARCHAR2(30) NOT NULL | Bank branch bame |
43 | GPAU_TARGTPRODID | Character(14) | VARCHAR2(14) NOT NULL | GPAUS - Stores the target Superannuation Fund's Product ID. Used in SuperEC processing. |
44 | GPAU_TARGET_URL | Character(254) | VARCHAR2(254) NOT NULL | E-service address used in SuperStream reporting |
45 | GPAU_ER_ABN | Character(11) | VARCHAR2(11) NOT NULL | Employer ABN |
46 | GPAU_ER_NAME | Character(200) | VARCHAR2(200) NOT NULL | Name of the employer |
47 | GPAU_SUPER_EMPLID | Character(20) | VARCHAR2(20) NOT NULL | The ID provide by Super Fund to the employer |
48 | LOCATION_DESCR | Character(30) | VARCHAR2(30) NOT NULL | Location Description |
49 | PRD_BGN_DT | Date(10) | DATE | Period Begin Date |
50 | PRD_END_DT | Date(10) | DATE | Pay Period End Date |