PROCESS_INSTANCEY/N Table Edit
Default Value: N
BS_MRG_PRJ_AET(SQL Table) |
Index Back |
|---|---|
BS Merge Prj AE State tblBASS-NSN-02/18/03 AE state table to support the merging of projects on the Stage tables. Log: 1) BASS_NSN_252068 - Add RDA override flag(BS_OVR_BASS_FL) to copy BS_BLD_PROJ table from BASS. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PROCESS_INSTANCE |
Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 2 | OPRID | Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 3 | RUN_CNTL_ID | Character(30) | VARCHAR2(30) NOT NULL | Run Control ID |
| 4 | SR_LICENSE_GRP | Character(18) | VARCHAR2(18) NOT NULL | License Group |
| 5 | SR_BUILD | Character(20) | VARCHAR2(20) NOT NULL | Activity |
| 6 | SR_BUILD_ID | Character(20) | VARCHAR2(20) NOT NULL | Build Id |
| 7 | SR_PRODUCT | Character(4) | VARCHAR2(4) NOT NULL | Product |
| 8 | PROJECTNAME | Character(30) | VARCHAR2(30) NOT NULL | Project Name (see PSPROJECTDEFN). |
| 9 | BS_DBNAME | Character(16) | VARCHAR2(16) NOT NULL | BASS-WTA-061402: Created new field for database reference. Info extracted from Data Connections. Used by various features of BASS. |
| 10 | BS_DBSERVER | Character(16) | VARCHAR2(16) NOT NULL | BASS-WTA-061402: Created new field for database server names pulled from Data Connection |
| 11 | BS_STG_DBSERVER | Character(16) | VARCHAR2(16) NOT NULL | BASS-WTA-061402: Created new field for database server names pulled from Data Connection |
| 12 | BS_DBTYPE | Character(30) | VARCHAR2(30) NOT NULL | BASS-WTA-061402: Created new field for database server names pulled from Data Connection Log: NSN_305167: Update to increase size to be sync with ED_BASS_VW. |
| 13 | BS_OVR_BASS_FL | Character(1) | VARCHAR2(1) NOT NULL |
BASS-NSN-252068: Flag to indicate if the Remote Data Access(RDA) file transfer process is to be overridden in the Merge process. This flag will be used when there is a tools issue with the RDA process.
Y/N Table Edit Default Value: N |