17380 CAM_LOV_USER_TYPES Entity Published / External 17195 AFSC/FMA/CAMS Data Objects Data Set Completed Contains user types/roles of each application. Loaded by batch 3994, 01-03-2013 16:38 Data Table Yes CUST_AUTH Contains user types/roles of each application. 1 LOV_USER_TYPE_SEQ NUMBER 22 Yes Yes Active Primary key sequence of CAM_LOV_USER_TYPES NUMBER 2 USER_TYPE_CODE VARCHAR2 30 Yes No Active Unique code for user type of each module. For example,N for NMFS, P for provider, C for captain VARCHAR2 3 USER_TYPE_DESC VARCHAR2 4000 No No Active Describes the user type VARCHAR2 4 APP_SEQ NUMBER 22 Yes No 38 Active Primary key sequence for MODULES table NUMBER CUST_AUTH.CAM_APPS 5 RECORD_HISTORY CLOB 4000 No No Active Entire record change history. CLOB 6 RECORD_JOURNAL_NOTE VARCHAR2 4000 No No Active Comment for journaling record. VARCHAR2 7 RECORD_APPROVED_BY_PERSON VARCHAR2 40 No No Active Person approved the record, such as QAQC manager for the record. Doesn't have to be a application user. VARCHAR2 8 RECORD_APPROVED_ON_DATE DATE 7 No No Active Date when the data approved by QAQC manager/personell. DATE 9 RECORD_COMPUTER_LOAD_BY_USER VARCHAR2 40 Yes No Active A application user who upload the record in to the database system. VARCHAR2 10 RECORD_COMPUTER_LOAD_ON_DATE TIMESTAMP(4) 11 Yes No 4 Active Date and time when the record loaded into the table. TIMESTAMP(4) 11 RECORD_CREATED_BY_PERSON VARCHAR2 40 No No Active Data collector or creator, doesn't have to be an application user. VARCHAR2 12 RECORD_CREATED_ON_DATE DATE 7 No No Active Date the record collected or created. Optional DATE 13 RECORD_EFFECTIVE_DATE DATE 7 No No Active The date on which the record takes effect. Optional DATE 14 RECORD_EXPIRATION_DATE DATE 7 No No Active The date on which the record is expired. Optional DATE 15 RECORD_LAST_EDITED_BY_USER VARCHAR2 40 Yes No Active The application user who changed the record lastly. VARCHAR2 16 RECORD_LAST_EDITED_ON_DATE TIMESTAMP(4) 11 Yes No 4 Active The date on which the record was changed lastly. TIMESTAMP(4) 17 RECORD_NUMBER_OF_EDITS NUMBER 22 No No Active Record revision number NUMBER 18 RECORD_SOFT_DELETED VARCHAR2 1 No No Active Soft delete flag. Optional. Can be used as temporary delete, before hard delete. VARCHAR2 19 RECORD_STEWARDSHIP VARCHAR2 40 No No Active A person that is responsible for maintaining a data element in a metadata registry. VARCHAR2 20 RECORD_CHANGE_COMMENT VARCHAR2 4000 No No Active Comment for data update. VARCHAR2 21 PARENT_USER_TYPE_SEQ NUMBER 22 No No Active The user type which includes this type. All of the privileges automatically available to the parent one. NUMBER gov.noaa.nmfs.inport:17380 Doug Turnbull 2013-01-03T16:38:22 SysAdmin InPortAdmin 2022-08-09T17:11:08 2016-05-18 Alaska Fisheries Science Center AFSC 7600 Sand Point Way N.E., Building 4 Seattle WA 98115 USA https://www.afsc.noaa.gov 0700-1700 Pacific Time 1001 Public No 2016-05-18 1 Year 2017-05-18