BS_BLDR_PROJ (SQL Table)	Index Back
Overall Build Proj Copy Table NSN 505852: Main table to manage the Builder project copy tables Log:

BS_BLDR_PROJ

(SQL Table)

Overall Build Proj Copy Table

NSN 505852: Main table to manage the Builder project copy tables Log:

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 SR_LICENSE_GRP Character(18) VARCHAR2(18) NOT NULL License Group
Prompt Table: SR_LICENSE_GRP

2 SR_BUILD Character(20) VARCHAR2(20) NOT NULL Activity
Prompt Table: BS_BLD_BUILD_VW

3 SR_BUILD_ID Character(20) VARCHAR2(20) NOT NULL Build Id
Prompt Table: BS_BLD_SRCH_VW

4 PROJECTNAME Character(30) VARCHAR2(30) NOT NULL Project Name (see PSPROJECTDEFN).

5 BS_SEQNUM Number(6,0) INTEGER NOT NULL BASS-WTA-061402: Created new field for sequence numbering the order to run project, scripts, etc. Used by build input form.

6 BS_BLD_PROJ_TYPE Character(4) VARCHAR2(4) NOT NULL BASS-WTA-061402: Created new field for defining project type (i.e. copy or export). Used by build input form
COPY=Copy Project
CPFF=Copy Project From File
EXPT=Export Project

7 SR_PRODUCT Character(4) VARCHAR2(4) NOT NULL Product
Prompt Table: BS_BLD_PROD_VW

8 BS_BLD_SOURCE_DB Character(16) VARCHAR2(16) NOT NULL BASS-WTA-061402: Created new field for project copy source database. Used by Build input form.
Prompt Table: BS_SRC_DB_VW1

9 BS_BLD_TARGET_DB Character(16) VARCHAR2(16) NOT NULL BASS-WTA-061402: Created new field for project copy source database. Used by Build input form.

10 BS_BLD_INCL_BUILD Character(1) VARCHAR2(1) NOT NULL BASS-WTA-061402: Created new field for flag indicating if build input should be included in build.

11 BS_BLD_COMP_STATUS Character(4) VARCHAR2(4) NOT NULL BASS-WTA-061402: Created new field for flag indicating if project should be merged into the single large build project.
CE=Copy Error
CS=Copy Successful
DV=Database Validation
IN=Initialized
IT=Incompatible Tools Release
MC=Manual Complete
MG=Merge Successful
MP=Project Name Invalid
NC=No Copy Req
PA=Pending Project Attachment
PR=Processing
PV=Project Not Validated
QU=Queued for project copy
SD=Database Access Error
TN=Tools $PS_HOME Not Found
Default Value: QU

12 LASTUPDDTTM 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.

13 LASTUPDOPRID Character(30) VARCHAR2(30) NOT NULL Specifies the User ID which made 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	SR_LICENSE_GRP	Character(18)	VARCHAR2(18) NOT NULL	License Group Prompt Table: SR_LICENSE_GRP
2	SR_BUILD	Character(20)	VARCHAR2(20) NOT NULL	Activity Prompt Table: BS_BLD_BUILD_VW
3	SR_BUILD_ID	Character(20)	VARCHAR2(20) NOT NULL	Build Id Prompt Table: BS_BLD_SRCH_VW
4	PROJECTNAME	Character(30)	VARCHAR2(30) NOT NULL	Project Name (see PSPROJECTDEFN).
5	BS_SEQNUM	Number(6,0)	INTEGER NOT NULL	BASS-WTA-061402: Created new field for sequence numbering the order to run project, scripts, etc. Used by build input form.
6	BS_BLD_PROJ_TYPE	Character(4)	VARCHAR2(4) NOT NULL	BASS-WTA-061402: Created new field for defining project type (i.e. copy or export). Used by build input form COPY=Copy Project CPFF=Copy Project From File EXPT=Export Project
7	SR_PRODUCT	Character(4)	VARCHAR2(4) NOT NULL	Product Prompt Table: BS_BLD_PROD_VW
8	BS_BLD_SOURCE_DB	Character(16)	VARCHAR2(16) NOT NULL	BASS-WTA-061402: Created new field for project copy source database. Used by Build input form. Prompt Table: BS_SRC_DB_VW1
9	BS_BLD_TARGET_DB	Character(16)	VARCHAR2(16) NOT NULL	BASS-WTA-061402: Created new field for project copy source database. Used by Build input form.
10	BS_BLD_INCL_BUILD	Character(1)	VARCHAR2(1) NOT NULL	BASS-WTA-061402: Created new field for flag indicating if build input should be included in build.
11	BS_BLD_COMP_STATUS	Character(4)	VARCHAR2(4) NOT NULL	BASS-WTA-061402: Created new field for flag indicating if project should be merged into the single large build project. CE=Copy Error CS=Copy Successful DV=Database Validation IN=Initialized IT=Incompatible Tools Release MC=Manual Complete MG=Merge Successful MP=Project Name Invalid NC=No Copy Req PA=Pending Project Attachment PR=Processing PV=Project Not Validated QU=Queued for project copy SD=Database Access Error TN=Tools $PS_HOME Not Found Default Value: QU
12	LASTUPDDTTM	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.
13	LASTUPDOPRID	Character(30)	VARCHAR2(30) NOT NULL	Specifies the User ID which made the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.