CNAO_CLNSTG_TBL (SQL Table)	Index Back
Records to be cleanup The table stores all staging table names and history table names that can be cleanup by CNAO_STG_CLN. Flag specifies whether if has BUSINESS_UNIT or BUSINESS_UNIT_GL. B: BUSINESS_UNIT . G: BUSINESS_UNIT_GL

CNAO_CLNSTG_TBL

(SQL Table)

Records to be cleanup

The table stores all staging table names and history table names that can be cleanup by CNAO_STG_CLN. Flag specifies whether if has BUSINESS_UNIT or BUSINESS_UNIT_GL. B: BUSINESS_UNIT . G: BUSINESS_UNIT_GL

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

2 FLAG Character(1) VARCHAR2(1) NOT NULL Flag
N=No
Y=Yes

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	RECNAME	Character(15)	VARCHAR2(15) NOT NULL	Record (Table) Name (see PSRECDEFN).
2	FLAG	Character(1)	VARCHAR2(1) NOT NULL	Flag N=No Y=Yes