FS_CCHOST_DTL (SQL Table)	Index Back
CC Hosting Conversion Tables 02/06/12 EGS: Created

FS_CCHOST_DTL

(SQL Table)

CC Hosting Conversion Tables

02/06/12 EGS: Created

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 RECNAME Character(15) VARCHAR2(15) NOT NULL Record (Table) Name (see PSRECDEFN).

2 CONV_STATUS Character(1) VARCHAR2(1) NOT NULL 02/22/12 EGS: Created
1=Not Converted
2=In Process
3=Complete
4=Incomplete
Default Value: 1

3 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance

4 SQLID Character(30) VARCHAR2(30) NOT NULL SQL Object Identifier. This column has different meanings depending upon value of SQLTYPE
SQLTYPE = 0: SQL object name
SQLTYPE = 1: Application Engine Step Identifier
SQLTYPE = 2: RECNAME
SQLTYPE = 6: Application Engine XSLT (XML definition)

5 AE_SECTION Character(8) VARCHAR2(8) NOT NULL Section

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	RECNAME	Character(15)	VARCHAR2(15) NOT NULL	Record (Table) Name (see PSRECDEFN).
2	CONV_STATUS	Character(1)	VARCHAR2(1) NOT NULL	02/22/12 EGS: Created 1=Not Converted 2=In Process 3=Complete 4=Incomplete Default Value: 1
3	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
4	SQLID	Character(30)	VARCHAR2(30) NOT NULL	SQL Object Identifier. This column has different meanings depending upon value of SQLTYPE SQLTYPE = 0: SQL object name SQLTYPE = 1: Application Engine Step Identifier SQLTYPE = 2: RECNAME SQLTYPE = 6: Application Engine XSLT (XML definition)
5	AE_SECTION	Character(8)	VARCHAR2(8) NOT NULL	Section