FS_CCHOST_CNV

(SQL Table)
Index Back

CC Hosting Conversion

01/04/12 EGS: Created

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
2 RUN_CNTL_ID Character(30) VARCHAR2(30) NOT NULL Run Control ID
3 PROCESS_FREQUENCY Character(1) VARCHAR2(1) NOT NULL Process Frequency
A=Always Process
N=Don't Run
O=Process Once

Default Value: A

4 PROCESS_STATUS Character(1) VARCHAR2(1) NOT NULL Process Status
A=Active
C=Successfully Completed
E=Completed With Errors
N=Not Yet Processed
P=Processing Now
X=No Success

Default Value: N

5 PROCESS_ORIG Character(1) VARCHAR2(1) NOT NULL Process Origin
N=Other Source
P=Process Scheduler
6 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
7 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
8 DTTM_STAMP_SEC DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
9 CC_PROF_OPT Character(1) VARCHAR2(1) NOT NULL Credit Card Profile Option
0=No Tokenization
1=Create Profiles Before
2=Create Profiles After

Default Value: 1

10 CONV_INACTIVE Character(1) VARCHAR2(1) NOT NULL Convert Inactive Customers

Y/N Table Edit

Default Value: N

11 MIN_KEY_SEPARATOR Character(2) VARCHAR2(2) NOT NULL Key Field Seperator

Default Value: /

12 CC_PROF_PURGE Character(1) VARCHAR2(1) NOT NULL Profile Purging Option
0=Do Not Purge Profiles
1=�After Settlement
2=�After
13 CC_PROF_DAYS Number(4,0) SMALLINT NOT NULL Days
14 CC_HOST_CUTOFF_DT Date(10) DATE Transaction Cut Off Date