DP_TABLENAMEDP_TRANSFERSPEC1=Transfer Data
2=Clear Interface Table
O=No Update
0=No Deletion
1=Delete Transferred
2=Delete All After Transfer
Y/N Table Edit
Y/N Table Edit
Y/N Table Edit
Y/N Table Edit
DP_DFTRANSSPECS(SQL Table) |
Index Back |
|---|---|
Transfer SpecificastionsTransfer Specificastions |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | DP_TABLENAME |
Character(50) | VARCHAR2(50) NOT NULL | DP_TABLENAME |
| 2 | DP_TRANSFERSPEC |
Character(20) | VARCHAR2(20) NOT NULL | DP_TRANSFERSPEC |
| 3 | DP_CAPTION | Character(30) | VARCHAR2(30) NOT NULL | DP_CAPTION |
| 4 | DP_UPDATECONTROL | Character(4) | VARCHAR2(4) NOT NULL |
DP_UPDATECONTROL
1=Transfer Data 2=Clear Interface Table O=No Update |
| 5 | DP_INTERFACERECS | Character(4) | VARCHAR2(4) NOT NULL |
DP_INTERFACERECS
0=No Deletion 1=Delete Transferred 2=Delete All After Transfer |
| 6 | DP_ACCUMULATEDMD | Character(1) | VARCHAR2(1) NOT NULL |
DP_ACCUMULATEDMD
Y/N Table Edit |
| 7 | DP_CREATEITEMS | Character(1) | VARCHAR2(1) NOT NULL |
DP_CREATEITEMS
Y/N Table Edit |
| 8 | DP_CREATECODES | Character(1) | VARCHAR2(1) NOT NULL |
DP_CREATECODES
Y/N Table Edit |
| 9 | DP_ACCUMULATEVALS | Character(1) | VARCHAR2(1) NOT NULL |
DP_ACCUMULATEVALS
Y/N Table Edit |
| 10 | DP_ROLLPERIODS | Signed Number(4,0) | DECIMAL(3) NOT NULL | DP_ROLLPERIODS |
| 11 | DP_RESETPERCENT | Number(13,2) | DECIMAL(12,2) NOT NULL | DP_RESETPERCENT |