PAY_CYCLEPrompt Table: SP_PYCYCL_NONVW
PAY_CYCLE_SEQ_NUMBANK_SETIDPrompt Table: SP_SETBNK_NONVW
DFT_MASTER_IDAPD_APPROVE_VW3(SQL View) |
Index Back |
|---|---|
DraftApprovalPanelDraftID SPHHeader Line |
| SELECT DISTINCT PAY_CYCLE ,PAY_CYCLE_SEQ_NUM ,BANK_SETID ,DFT_MASTER_ID ,BANK_CD ,BANK_ACCT_KEY ,DFT_GROUP_CD ,PYMNT_SEPARATE FROM PS_APD_DRAFT_STG |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PAY_CYCLE |
Character(6) | VARCHAR2(6) NOT NULL |
Pay Cycle
Prompt Table: SP_PYCYCL_NONVW |
| 2 | PAY_CYCLE_SEQ_NUM |
Number(6,0) | INTEGER NOT NULL | Pay Cycle Sequence Number |
| 3 | BANK_SETID |
Character(5) | VARCHAR2(5) NOT NULL |
The PeopleSoft tableset ID associated with a given bank/counterparty.
Prompt Table: SP_SETBNK_NONVW |
| 4 | DFT_MASTER_ID |
Character(10) | VARCHAR2(10) NOT NULL | Draft Master ID |
| 5 | BANK_CD | Character(5) | VARCHAR2(5) NOT NULL | Bank Code |
| 6 | BANK_ACCT_KEY | Character(4) | VARCHAR2(4) NOT NULL | A user defined unique identifier that facilitates the identification of a given account with a given bank |
| 7 | DFT_GROUP_CD | Character(5) | VARCHAR2(5) NOT NULL | Draft Group Code |
| 8 | PYMNT_SEPARATE | Character(1) | VARCHAR2(1) NOT NULL | Separate Payment |