UPG_CRHST_AET

(SQL Table)
Index Back

Upgrade Table for Credit Card

Upgrade Table for Credit Card. Used in AE Program as a State Record. AE Program Name : RB_UPG_CRHST

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
2 RUN_CNTL_ID Character(30) VARCHAR2(30) NOT NULL Run Control ID
3 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
4 APPLICATION_ID Character(30) VARCHAR2(30) NOT NULL Defines the Application ID for the given Card Application (e.g. stores CASE_ID for Support or EXTERNAL_ID for Order Capture)
5 HIST_SEQ Number(9,0) DECIMAL(9) NOT NULL History Sequence Number to be used in the History Records
6 CR_CARD_NBR Character(44) VARCHAR2(44) NOT NULL "See OM
7 CR_CARD_NBR_1 Character(44) VARCHAR2(44) NOT NULL Credit Card Number Field. To show unmasked Credit Card Number Used in CRM - CDM Credit Card Pages