GP_PMT_RCPID_VW(SQL View) |
Index Back |
---|---|
Pmt Recipients by CAL RUN IDPromptview used for selecting recipient ID as selection criterion against the payment table |
SELECT DISTINCT P.CAL_RUN_ID , P.RECIPIENT_ID , R.DESCR FROM PS_GP_PAYMENT P , PS_RECIPIENT R WHERE P.RECIPIENT_ID=R.RECIPIENT_ID |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | Character(18) | VARCHAR2(18) NOT NULL | Calendar Run Id | |
2 | Character(8) | VARCHAR2(8) NOT NULL | Payment recipient ID | |
3 | RECIPIENT_NAME | Character(30) | VARCHAR2(30) NOT NULL | Recipient Name |