| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 PTIAAUJOBNAME |
Character(100) |
VARCHAR2(100) NOT NULL |
Job Name
|
| 2 |
PTIAAUADHOCFLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Job Type
A=Ad hoc
S=Scheduled
|
| 3 |
RUNDATE |
Date(10) |
DATE |
Process Scheduler Run Date
|
| 4 |
RUNTIME |
Time(15) |
TIMESTAMP |
Process Scheduler Process Run Time
|
| 5 |
RECURNAME |
Character(30) |
VARCHAR2(30) NOT NULL |
Recurrence Name
|
| 6 |
PTIAMDACTIVITY |
Character(4) |
VARCHAR2(4) NOT NULL |
Activity
BKP=BackUp Metadata
LNG=Load Languages
MTGT=Sync multiple Targets
PUM=Fetch Old Metadata
RST=Restore Metadata
SYNC=Sync Latest Instance
TGT=Fetch Target Data
UMO=Sync Usage Monitor
|
| 7 |
PTIAMDACTPREF |
Character(4) |
VARCHAR2(4) NOT NULL |
Multi Job Preference
ALL=All
NONE=None
SELE=Selected
Default Value: NONE
|
| 8 |
PTIADBNAME |
Character(8) |
VARCHAR2(8) NOT NULL |
Database Name
Prompt Table:
PTIAMDDBS_DVW
|
| 9 |
PTIAMD_MRGREPFLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Merge Repository
Y/N Table Edit
|
| 10 |
PTIAMD_PAUFLG |
Character(1) |
VARCHAR2(1) NOT NULL |
PUM Automated Updates
Y/N Table Edit
|
| 11 |
PTIAMD_CSTREPFLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Cust Repository
Y/N Table Edit
|
| 12 |
PTIAMD_PKGDEFFLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Package Definition
Y/N Table Edit
|
| 13 |
PTIAMD_TSTREPFLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Test Repository
Y/N Table Edit
|
| 14 |
PTIALANGTGT |
Character(2) |
VARCHAR2(2) NOT NULL |
Target Language
A=Active
IA=Inactive
|
| 15 |
PTIALANGMNL |
Character(2) |
VARCHAR2(2) NOT NULL |
Manual Select
A=Active
IA=Inactive
|
| 16 |
PTIAMDLNFLG_ARA |
Character(1) |
VARCHAR2(1) NOT NULL |
ARABIC
Y/N Table Edit
|
| 17 |
PTIAMDLNFLG_BUL |
Character(1) |
VARCHAR2(1) NOT NULL |
Bulgarian
Y/N Table Edit
|
| 18 |
PTIAMDLNFLG_CFR |
Character(1) |
VARCHAR2(1) NOT NULL |
Canadian French
Y/N Table Edit
|
| 19 |
PTIAMDLNFLG_CRO |
Character(1) |
VARCHAR2(1) NOT NULL |
Croatian
Y/N Table Edit
|
| 20 |
PTIAMDLNFLG_CZE |
Character(1) |
VARCHAR2(1) NOT NULL |
Czech
Y/N Table Edit
|
| 21 |
PTIAMDLNFLG_DAN |
Character(1) |
VARCHAR2(1) NOT NULL |
Danish
Y/N Table Edit
|
| 22 |
PTIAMDLNFLG_DUT |
Character(1) |
VARCHAR2(1) NOT NULL |
Dutch
Y/N Table Edit
|
| 23 |
PTIAMDLNFLG_ESP |
Character(1) |
VARCHAR2(1) NOT NULL |
Spanish
Y/N Table Edit
|
| 24 |
PTIAMDLNFLG_FIN |
Character(1) |
VARCHAR2(1) NOT NULL |
Finnish
Y/N Table Edit
|
| 25 |
PTIAMDLNFLG_FRA |
Character(1) |
VARCHAR2(1) NOT NULL |
French
Y/N Table Edit
|
| 26 |
PTIAMDLNFLG_GER |
Character(1) |
VARCHAR2(1) NOT NULL |
German
Y/N Table Edit
|
| 27 |
PTIAMDLNFLG_GRK |
Character(1) |
VARCHAR2(1) NOT NULL |
Greek
Y/N Table Edit
|
| 28 |
PTIAMDLNFLG_HEB |
Character(1) |
VARCHAR2(1) NOT NULL |
Hebrew
Y/N Table Edit
|
| 29 |
PTIAMDLNFLG_HUN |
Character(1) |
VARCHAR2(1) NOT NULL |
Hungarian
Y/N Table Edit
|
| 30 |
PTIAMDLNFLG_ITA |
Character(1) |
VARCHAR2(1) NOT NULL |
Italian
Y/N Table Edit
|
| 31 |
PTIAMDLNFLG_JPN |
Character(1) |
VARCHAR2(1) NOT NULL |
Japanese
Y/N Table Edit
|
| 32 |
PTIAMDLNFLG_KOR |
Character(1) |
VARCHAR2(1) NOT NULL |
Korean
Y/N Table Edit
|
| 33 |
PTIAMDLNFLG_MAY |
Character(1) |
VARCHAR2(1) NOT NULL |
Bahasa Malay
Y/N Table Edit
|
| 34 |
PTIAMDLNFLG_NOR |
Character(1) |
VARCHAR2(1) NOT NULL |
Norwegian
Y/N Table Edit
|
| 35 |
PTIAMDLNFLG_POL |
Character(1) |
VARCHAR2(1) NOT NULL |
Polish
Y/N Table Edit
|
| 36 |
PTIAMDLNFLG_POR |
Character(1) |
VARCHAR2(1) NOT NULL |
Portuguese
Y/N Table Edit
|
| 37 |
PTIAMDLNFLG_ROM |
Character(1) |
VARCHAR2(1) NOT NULL |
Romanian
Y/N Table Edit
|
| 38 |
PTIAMDLNFLG_RUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Russian
Y/N Table Edit
|
| 39 |
PTIAMDLNFLG_SER |
Character(1) |
VARCHAR2(1) NOT NULL |
Serbian
Y/N Table Edit
|
| 40 |
PTIAMDLNFLG_SLK |
Character(1) |
VARCHAR2(1) NOT NULL |
Slovak
Y/N Table Edit
|
| 41 |
PTIAMDLNFLG_SLV |
Character(1) |
VARCHAR2(1) NOT NULL |
Slovenian
Y/N Table Edit
|
| 42 |
PTIAMDLNFLG_SVE |
Character(1) |
VARCHAR2(1) NOT NULL |
Swedish
Y/N Table Edit
|
| 43 |
PTIAMDLNFLG_THA |
Character(1) |
VARCHAR2(1) NOT NULL |
Thai
Y/N Table Edit
|
| 44 |
PTIAMDLNFLG_TUR |
Character(1) |
VARCHAR2(1) NOT NULL |
Turkish
Y/N Table Edit
|
| 45 |
PTIAMDLNFLG_UKE |
Character(1) |
VARCHAR2(1) NOT NULL |
UK English
Y/N Table Edit
|
| 46 |
PTIAMDLNFLG_VIE |
Character(1) |
VARCHAR2(1) NOT NULL |
Vietnamese
Y/N Table Edit
|
| 47 |
PTIAMDLNFLG_ZHS |
Character(1) |
VARCHAR2(1) NOT NULL |
Simplified Chinese
Y/N Table Edit
|
| 48 |
PTIAMDLNFLG_ZHT |
Character(1) |
VARCHAR2(1) NOT NULL |
Traditional Chinese
Y/N Table Edit
|
| 49 |
PTIAMDPC_AE |
Character(1) |
VARCHAR2(1) NOT NULL |
Application Engine
Y/N Table Edit
|
| 50 |
PTIAMDSQLFLG |
Character(1) |
VARCHAR2(1) NOT NULL |
SQLs
|
| 51 |
PTIAMDXSLTFLG |
Character(1) |
VARCHAR2(1) NOT NULL |
XSLT Definitions
|
| 52 |
PTIAMDPC_AP |
Character(1) |
VARCHAR2(1) NOT NULL |
Application Package
|
| 53 |
PTIAMDPC_BC |
Character(1) |
VARCHAR2(1) NOT NULL |
Business Component
|
| 54 |
PTIAMDPC_CI |
Character(1) |
VARCHAR2(1) NOT NULL |
CI Propoerty
|
| 55 |
PTIAMDPC_CO |
Character(1) |
VARCHAR2(1) NOT NULL |
Component
|
| 56 |
PTIAMDPC_CR |
Character(1) |
VARCHAR2(1) NOT NULL |
Component Record
|
| 57 |
PTIAMDPC_CRF |
Character(1) |
VARCHAR2(1) NOT NULL |
Component RecField
|
| 58 |
PTIAMDPC_MC |
Character(1) |
VARCHAR2(1) NOT NULL |
Message Channel
|
| 59 |
PTIAMDPC_MENU |
Character(1) |
VARCHAR2(1) NOT NULL |
Menu
|
| 60 |
PTIAMDPC_MSG |
Character(1) |
VARCHAR2(1) NOT NULL |
Message
|
| 61 |
PTIAMDPC_PF |
Character(1) |
VARCHAR2(1) NOT NULL |
Page Field
|
| 62 |
PTIAMDPC_PG |
Character(1) |
VARCHAR2(1) NOT NULL |
Page
|
| 63 |
PTIAMDPC_REC |
Character(1) |
VARCHAR2(1) NOT NULL |
Record
|
| 64 |
PTIAMDPC_RF |
Character(1) |
VARCHAR2(1) NOT NULL |
Record Field
|
| 65 |
PTIAMDPC_SUB |
Character(1) |
VARCHAR2(1) NOT NULL |
Subscription
|
| 66 |
PTIAMDPCFLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Peoplecode
|