Slide Menu
Search Help Show/Hide Menu

Item Identification

Title: Table: TIP_AGENT_XREF
Short Name: TIP_AGENT_XREF
Status: Completed
Abstract:

Used to reassign agent or repsonsible party when data was converted from TIP to TIPONELINE format

Notes:

Loaded by batch 2005, 12-03-2007 10:12

Entity Information

Entity Type: Data Table
Active Version?: Yes
Schema Name: TIPONLINE
Description:

Used to reassign agent or repsonsible party when data was converted from TIP to TIPONELINE format

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
SEQUENCE VARCHAR2 Sequence Number in TIPONLINE schema
100
PC_SEQ VARCHAR2 PC Sequence Number (from historiacl TIP data)
100
AGENT VARCHAR2 Two letter code for Agent
100
LASTNAME VARCHAR2 Agent Last Name
100
FIRSTNAME VARCHAR2 Agent First Name
100
AGENCY VARCHAR2 Agency Responisble For The Data
100
NEW_FIRST VARCHAR2 New First Name
100
NEW_LAST VARCHAR2 New Last Name
100
NEW_AGENCY VARCHAR2 New Agency Name
100
USERID VARCHAR2 Oracle Id Of Port Agent or other party that is responsible for the data
100
MOVED_TO_MASTER_DATE DATE Data records were moved to master tables

Attribute Details

SEQUENCE

CC ID: 22739
Seq. Order: 1
Data Storage Type: VARCHAR2
Max Length: 11
Required: No
Primary Key: No
Status: Active
Description:

Sequence Number in TIPONLINE schema

General Data Type: VARCHAR2

PC_SEQ

CC ID: 22740
Seq. Order: 2
Data Storage Type: VARCHAR2
Max Length: 11
Required: No
Primary Key: No
Status: Active
Description:

PC Sequence Number (from historiacl TIP data)

General Data Type: VARCHAR2

AGENT

CC ID: 22741
Seq. Order: 3
Data Storage Type: VARCHAR2
Max Length: 2
Required: No
Primary Key: No
Status: Active
Description:

Two letter code for Agent

General Data Type: VARCHAR2

LASTNAME

CC ID: 22742
Seq. Order: 4
Data Storage Type: VARCHAR2
Max Length: 15
Required: No
Primary Key: No
Status: Active
Description:

Agent Last Name

General Data Type: VARCHAR2

FIRSTNAME

CC ID: 22743
Seq. Order: 5
Data Storage Type: VARCHAR2
Max Length: 15
Required: No
Primary Key: No
Status: Active
Description:

Agent First Name

General Data Type: VARCHAR2

AGENCY

CC ID: 22744
Seq. Order: 6
Data Storage Type: VARCHAR2
Max Length: 20
Required: No
Primary Key: No
Status: Active
Description:

Agency Responisble For The Data

General Data Type: VARCHAR2

NEW_FIRST

CC ID: 22745
Seq. Order: 7
Data Storage Type: VARCHAR2
Max Length: 15
Required: No
Primary Key: No
Status: Active
Description:

New First Name

General Data Type: VARCHAR2

NEW_LAST

CC ID: 22746
Seq. Order: 8
Data Storage Type: VARCHAR2
Max Length: 15
Required: No
Primary Key: No
Status: Active
Description:

New Last Name

General Data Type: VARCHAR2

NEW_AGENCY

CC ID: 22747
Seq. Order: 9
Data Storage Type: VARCHAR2
Max Length: 20
Required: No
Primary Key: No
Status: Active
Description:

New Agency Name

General Data Type: VARCHAR2

USERID

CC ID: 22748
Seq. Order: 10
Data Storage Type: VARCHAR2
Max Length: 20
Required: No
Primary Key: No
Status: Active
Description:

Oracle Id Of Port Agent or other party that is responsible for the data

General Data Type: VARCHAR2

MOVED_TO_MASTER_DATE

CC ID: 22749
Seq. Order: 11
Data Storage Type: DATE
Max Length: 7
Required: No
Primary Key: No
Status: Active
Description:

Data records were moved to master tables

General Data Type: DATE

Catalog Details

Catalog Item ID: 6601
GUID: gov.noaa.nmfs.inport:6601
Metadata Record Created By: Lee M Weinberger
Metadata Record Created: 2007-12-03 10:12+0000
Metadata Record Last Modified By: Lee M Weinberger
Metadata Record Last Modified: 2021-11-04 13:14+0000
Metadata Record Published: 2021-11-04
Owner Org: SEFSC
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Next Review Date: 2022-11-05