OHDSI Home | Forums | Wiki | Github

Observation period end datetime exceeds Oracle's 30 character column limit

CDM Builders
#1

‘observation_period_end_datetime’ exceeds that allowable length of a column name (30 characters) for Oracle sites that are still at version 11g.

#2

So sorry to see this. I know Oracle 12cR2 does support the longer names. The question is what to do for now.

  1. Truncate those two fields to 30 chars for now (for everyone I mean)

observation_period_start_datet
observation_period_end_datetim

  1. Use an alternate name for those two for now

observation_period_start_dttm
observation_period_end_dttm

  1. Or shorten their table name

obs_period_start_datetime
obs_period_end_datetime

  1. Or change our approach to the entire database, such as don’t use table names in datetime fields anywhere

start_datetime
end_datetime

Given that eventually groups will move off Oracle 11g, I like doing something for those two fields in that one table, and reverting to the verbose version a year or two (or whatever) from now, staying consistent with our original plan.

George

#3

I’d like to give this statement one thousand thumbs up.

1 Like
t