EMPLIDEMPL_RCDRUN_TYPEINSTANCEA=Cash
C=Check
O=Pay Primary Account Only
P=Postal Order
T=Bank Transfer
U=Use Normal Distribution
W=Wire Transfer
GP_PAY_DIST(SQL View) |
Index Back |
|---|---|
GP Chatbot PaymentGP Chatbot Payment |
| SELECT d.emplid ,d.empl_rcd ,d.run_type ,d.instance , ( SELECT bank_nm FROM ps_bank_ec_tbl a ,ps_pye_bankacct p WHERE p.emplid=d.emplid AND p.account_id=d.account_id AND a.bank_Cd=p.bank_Cd AND a.country_Cd=p.country_Cd) ,payment_mthd ,percent_rate ,x.xlatlongname , E.jobcode_descr FROM ps_GP_NET_DIST_DTL d ,psxlatitem x , PS_JOB_CURR_VW1 E WHERE d.effdt=( SELECT MAX(effdt) FROM ps_gp_net_dist_dtl WHERE emplid=d.emplid AND empl_Rcd=d.empl_Rcd AND run_type=d.run_type) AND x.fieldname='PAYMENT_MTHD' AND x.fieldvalue=d.payment_mthd AND E.emplid=d.emplid AND E.empl_rcd=d.empl_Rcd |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 2 | EMPL_RCD |
Number(3,0) | SMALLINT NOT NULL | Empl Record |
| 3 | RUN_TYPE |
Character(10) | VARCHAR2(10) NOT NULL | Run Type Name |
| 4 | INSTANCE |
Number(3,0) | SMALLINT NOT NULL | Instance Number |
| 5 | BANK_NM | Character(40) | VARCHAR2(40) NOT NULL | Bank Name |
| 6 | PAYMENT_MTHD | Character(1) | VARCHAR2(1) NOT NULL |
Payment Method
A=Cash C=Check O=Pay Primary Account Only P=Postal Order T=Bank Transfer U=Use Normal Distribution W=Wire Transfer |
| 7 | PERCENT_RATE | Number(6,2) | DECIMAL(5,2) NOT NULL | Percent |
| 8 | XLATLONGNAME | Character(30) | VARCHAR2(30) NOT NULL | Translate Long Name |
| 9 | JOBTITLE | Character(30) | VARCHAR2(30) NOT NULL | Job Title |