CHNG_MAP_TMPLT_IDRECNAME_TARGETFIELDTYPEDefault Value: 0
FIELDNUMFIELDNAME_TARGETPrompt Table: RECFIELD_TAR_VW
FIELDNAME_SOURCEPrompt Table: RECFIELD_SRC_VW
FIELDNAMECHNG_MAP_FLD_WS(SQL Table) |
Index Back |
|---|---|
Change Map Field Work ScrollChange Map Field Work Scroll |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | CHNG_MAP_TMPLT_ID |
Character(10) | VARCHAR2(10) NOT NULL | Change Template ID |
| 2 | RECNAME_TARGET |
Character(15) | VARCHAR2(15) NOT NULL | Target Recname |
| 3 | FIELDTYPE |
Number(2,0) | SMALLINT NOT NULL |
Field Type (from PSST0101 Ref.)
Default Value: 0 |
| 4 | FIELDNUM |
Number(4,0) | SMALLINT NOT NULL | Field Number |
| 5 | FIELDNAME_TARGET |
Character(18) | VARCHAR2(18) NOT NULL |
Allocations Target amount field
Prompt Table: RECFIELD_TAR_VW |
| 6 | FIELDNAME_SOURCE |
Character(18) | VARCHAR2(18) NOT NULL |
Source Fieldname
Prompt Table: RECFIELD_SRC_VW |
| 7 | FIELDNAME |
Character(18) | VARCHAR2(18) NOT NULL | Field Name (see PSDBFIELD). |
| 8 | RECNAME_SOURCE | Character(15) | VARCHAR2(15) NOT NULL | Source Recname |