PC_LAST_NO_USED (SQL Table)	Index Back
Last Number Used This table stores fields that are system-generated. For each field on this table, it holds the last number used.

PC_LAST_NO_USED

(SQL Table)

Last Number Used

This table stores fields that are system-generated. For each field on this table, it holds the last number used.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 LAST_COMPRESS_ID Number(10,0) DECIMAL(10) NOT NULL Compress ID is a unique identifier for a single run instance of the Project Compression Utility (PC_COMPRESS). Since Compress ID is system-generated, the LAST_COMPRESS_ID field holds the last Compress ID used by the system.

2 SEQ_TRANS_ID Number(15,0) DECIMAL(15) NOT NULL Sequence Transaction ID

3 DIST_TRANS_ID Number(15,0) DECIMAL(15) NOT NULL Distribution Transaction ID

4 FEEDER_SUM_ID Number(16,0) DECIMAL(16) NOT NULL Feeder Summarization ID relates the summed Project Transactions row to its corresponding detail transactions.
Default Value: 1

5 PRICE_SUM_ID Number(16,0) DECIMAL(16) NOT NULL Price Summarization ID relates the summed Project Transactions row in PC_PRICE_SUM to its corresponding detail transactions in PROJ_RESOURCE.
Default Value: 1

6 P6_LAST_RSRC_ID Number(16,0) DECIMAL(16) NOT NULL Used for P6 Resource ID autonumber generation. This field holds the last Resource ID used in the system.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	LAST_COMPRESS_ID	Number(10,0)	DECIMAL(10) NOT NULL	Compress ID is a unique identifier for a single run instance of the Project Compression Utility (PC_COMPRESS). Since Compress ID is system-generated, the LAST_COMPRESS_ID field holds the last Compress ID used by the system.
2	SEQ_TRANS_ID	Number(15,0)	DECIMAL(15) NOT NULL	Sequence Transaction ID
3	DIST_TRANS_ID	Number(15,0)	DECIMAL(15) NOT NULL	Distribution Transaction ID
4	FEEDER_SUM_ID	Number(16,0)	DECIMAL(16) NOT NULL	Feeder Summarization ID relates the summed Project Transactions row to its corresponding detail transactions. Default Value: 1
5	PRICE_SUM_ID	Number(16,0)	DECIMAL(16) NOT NULL	Price Summarization ID relates the summed Project Transactions row in PC_PRICE_SUM to its corresponding detail transactions in PROJ_RESOURCE. Default Value: 1
6	P6_LAST_RSRC_ID	Number(16,0)	DECIMAL(16) NOT NULL	Used for P6 Resource ID autonumber generation. This field holds the last Resource ID used in the system.