BS_MRG_MST_AET

(SQL Table)
Index Back

BS Merge Prj Mst State Tbl

NSN-505852: Merge on Master State table Log:

# 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 PROJECTNAME Character(30) VARCHAR2(30) NOT NULL Project Name (see PSPROJECTDEFN).
8 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.
9 BS_DBSERVER Character(16) VARCHAR2(16) NOT NULL BASS-WTA-061402: Created new field for database server names pulled from Data Connection
10 BS_STG_DBSERVER Character(16) VARCHAR2(16) NOT NULL BASS-WTA-061402: Created new field for database server names pulled from Data Connection
11 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.
12 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