PC_RES_ARC_SRCH (SQL View)	Index Back
Transaction History Search Search record for transaction history tables.

PC_RES_ARC_SRCH

(SQL View)

Transaction History Search

Search record for transaction history tables.

SELECT DISTINCT A.BUSINESS_UNIT , A.PROJECT_ID , A.DESCR , B.COMPRESS_ID , C.DTTM_STAMP FROM PS_PROJECT A , PS_PROJ_RES_ARCH B , PS_PC_COMPRESS_LOG C WHERE A.BUSINESS_UNIT = B.BUSINESS_UNIT AND A.PROJECT_ID = B.PROJECT_ID AND B.COMPRESS_ID = C.COMPRESS_ID

Related Language Record: PROJECT_LANG

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
Default Value: OPR_DEF_TBL_PC.BUSINESS_UNIT
Prompt Table: SP_BU_PC_NONVW

2 PROJECT_ID Character(15) VARCHAR2(15) NOT NULL Project Id ChartField
Default Value: OPR_DEF_TBL_PC.PROJECT_ID
Prompt Table: PROJECT_VW

3 DESCR Character(30) VARCHAR2(30) NOT NULL Description

4 COMPRESS_ID Number(10,0) DECIMAL(10) NOT NULL A unique identifier for a single run instance of the Project Compression Utility (PC_COMPRESS)

5 DTTM_STAMP 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.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit Default Value: OPR_DEF_TBL_PC.BUSINESS_UNIT Prompt Table: SP_BU_PC_NONVW
2	PROJECT_ID	Character(15)	VARCHAR2(15) NOT NULL	Project Id ChartField Default Value: OPR_DEF_TBL_PC.PROJECT_ID Prompt Table: PROJECT_VW
3	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
4	COMPRESS_ID	Number(10,0)	DECIMAL(10) NOT NULL	A unique identifier for a single run instance of the Project Compression Utility (PC_COMPRESS)
5	DTTM_STAMP	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.