PYCYCL_MAP_HDR(SQL Table) |
Index Back |
|---|---|
Payment mapping header |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  SOURCE_TXN |
Character(4) | VARCHAR2(4) NOT NULL |
Source Transaction
Prompt Table: PYMNT_SOURCE |
| 2 | MAP_TYPE |
Character(2) | VARCHAR2(2) NOT NULL |
Map Type
D1=Pay Cycle Data D2=Payment Data (Child) V1=Prenote Data W1=Withholding Data W2=Withholding Data (Child) Default Value: D1 |
| 3 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 4 | MAP_CHILD_REC_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Map Child Record ?
Y/N Table Edit |
| 5 | RECNAME | Character(15) | VARCHAR2(15) NOT NULL |
Record (Table) Name (see PSRECDEFN).
Prompt Table: RECDEFN_VW |
| 6 | RECNAME_UPDATE | Character(15) | VARCHAR2(15) NOT NULL |
Record to Update
Prompt Table: RECDEFN_VW |
| 7 | RECNAME_UPD_CPY | Character(15) | VARCHAR2(15) NOT NULL |
Copy of Record to Update
Prompt Table: RECDEFN_VW |