GPAU_CALPYENTGPAU_SMART_KEYGPAU_LODGEMENT_REFGPAU_COM_CTX_VW(SQL View) |
Index Back |
|---|---|
ComSuper - Context TableThis table stores the Key entity information used in ComSuper XBRL 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) , 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) , CASE WHEN A.GPAU_PYMT_MTHD = 'BPAY' THEN A.GPAU_CRN ELSE A.GPAU_LODGEMENT_REF END , 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_SS_CTX_DAT 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 AND C1.PAY_ENTITY = C.PAY_ENTITY AND C1.GP_PAYGROUP = C.GP_PAYGROUP) |
| # | 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 | JOBCODE_DESCR | Character(30) | VARCHAR2(30) NOT NULL | Job Code Description |
| 17 | GPAU_EMAIL_ADDR | Character(76) | VARCHAR2(76) NOT NULL | Supplier E-mail address |
| 18 | GPAU_PHONE_SERVICE | Character(2) | VARCHAR2(2) NOT NULL | Used in SS Report |
| 19 | PHONE | Character(24) | VARCHAR2(24) NOT NULL | Telephone |
| 20 | GPAU_SENDER_URL | Character(254) | VARCHAR2(254) NOT NULL | Sender E-Service Address |
| 21 | GPAU_ERROR_ENABLED | Character(1) | VARCHAR2(1) NOT NULL | Error handling enabled indicator |
| 22 | GPAU_RECEIVER_ABN | Character(11) | VARCHAR2(11) NOT NULL | Receiver ABN |
| 23 | GPAU_RECEIVER_NAME | Character(76) | VARCHAR2(76) NOT NULL | Receiver Name |
| 24 | GPAU_PAYER_ABN | Character(11) | VARCHAR2(11) NOT NULL | Payer ABN |
| 25 | GPAU_PAYER_NM | Character(200) | VARCHAR2(200) NOT NULL | Payer Name |
| 26 | GPAU_BRANCH_EC_CD | Character(17) | VARCHAR2(17) NOT NULL | Branch Code |
| 27 | GPAU_ACCOUNT_EC_ID | Character(35) | VARCHAR2(35) NOT NULL | Account Number used in banking. |
| 28 | GPAU_ACCOUNT_NAME | Character(50) | VARCHAR2(50) NOT NULL | Account Name |
| 29 | GPAU_BRANCH_NAME | Character(30) | VARCHAR2(30) NOT NULL | Bank Branch Name |
| 30 | GPAU_BANK_NM | Character(40) | VARCHAR2(40) NOT NULL | Bank Name |
| 31 | GPAU_PAYEE_ABN | Character(11) | VARCHAR2(11) NOT NULL | Payee ABN |
| 32 | GPAU_PYMT_MTHD | Character(15) | VARCHAR2(15) NOT NULL | Payment Method |
| 33 | DEBIT_DT | Date(10) | DATE | Debit Date |
| 34 | GPAU_CRN | Character(20) | VARCHAR2(20) NOT NULL | Customer Reference Number |
| 35 | GPAU_BILLER_CODE | Character(20) | VARCHAR2(20) NOT NULL | BPAY Biller Code |
| 36 | PAYMENT_AMT | Number(19,3) | DECIMAL(18,3) NOT NULL | Payment Amount |
| 37 | BRANCH_EC_CD | Character(17) | VARCHAR2(17) NOT NULL | Bank Branch ID |
| 38 | ACCOUNT_EC_ID | Character(35) | VARCHAR2(35) NOT NULL | Account Number used in banking. |
| 39 | ACCOUNT_NAME | Character(50) | VARCHAR2(50) NOT NULL | Account Name |
| 40 | BANK_NM | Character(40) | VARCHAR2(40) NOT NULL | Bank Name |
| 41 | GPAU_BRANCH_NM | Character(30) | VARCHAR2(30) NOT NULL | Bank branch bame |
| 42 | GPAU_TARGTPRODID | Character(14) | VARCHAR2(14) NOT NULL | GPAUS - Stores the target Superannuation Fund's Product ID. Used in SuperEC processing. |
| 43 | GPAU_TARGET_URL | Character(254) | VARCHAR2(254) NOT NULL | E-service address used in SuperStream reporting |
| 44 | GPAU_ER_ABN | Character(11) | VARCHAR2(11) NOT NULL | Employer ABN |
| 45 | GPAU_ER_NAME | Character(200) | VARCHAR2(200) NOT NULL | Name of the employer |
| 46 | GPAU_SUPER_EMPLID | Character(20) | VARCHAR2(20) NOT NULL | The ID provide by Super Fund to the employer |
| 47 | LOCATION_DESCR | Character(30) | VARCHAR2(30) NOT NULL | Location Description |
| 48 | PRD_BGN_DT | Date(10) | DATE | Period Begin Date |
| 49 | PRD_END_DT | Date(10) | DATE | Pay Period End Date |