BS_BLD_PROJ (SQL Table)	Index Back
Copy of Project Input Bld tbl NSN 10/02/2003: Copy of project input build table LOG: 1) 248212 - update to eliminate record layout dependancy on BS_BLD_PROJECTS table.

BS_BLD_PROJ

(SQL Table)

Copy of Project Input Bld tbl

NSN 10/02/2003: Copy of project input build table LOG: 1) 248212 - update to eliminate record layout dependancy on BS_BLD_PROJECTS table.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 SR_LICENSE_GRP Character(18) VARCHAR2(18) NOT NULL License Group

2 SR_BUILD Character(20) VARCHAR2(20) NOT NULL Activity

3 SR_BUILD_ID Character(20) VARCHAR2(20) NOT NULL Build Id

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

8 BS_BLD_VAL_FLAG Character(1) VARCHAR2(1) NOT NULL BASS-WTA-061402: Created new field for build project validation flag. Used by Build input form.

9 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.

10 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.

11 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.

12 BS_BLD_INCL_MERGE Character(1) VARCHAR2(1) NOT NULL BASS-WTA-061402: Created new field for flag indicating if project should be merged into the single large build project.

13 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

14 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.

15 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
2	SR_BUILD	Character(20)	VARCHAR2(20) NOT NULL	Activity
3	SR_BUILD_ID	Character(20)	VARCHAR2(20) NOT NULL	Build Id
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
8	BS_BLD_VAL_FLAG	Character(1)	VARCHAR2(1) NOT NULL	BASS-WTA-061402: Created new field for build project validation flag. Used by Build input form.
9	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.
10	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.
11	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.
12	BS_BLD_INCL_MERGE	Character(1)	VARCHAR2(1) NOT NULL	BASS-WTA-061402: Created new field for flag indicating if project should be merged into the single large build project.
13	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
14	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.
15	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.