I could use some help translating the contracts.
Contracts have a Type.
the field is 'CONTRACTTYPE' and is a single letter value.
CONTRACTTYPE appear to be in the "BPLANS" table.
However I end up with multiple "Contract types" that use the same value "M, T, G or H"
I could see if the type was tied using RECID, but it appears to be tied using a value that is not unique... I must be misunderstanding how these relationships are created/managed.
Any help would be appreciated.
Contracts have a Type.
the field is 'CONTRACTTYPE' and is a single letter value.
CONTRACTTYPE appear to be in the "BPLANS" table.
However I end up with multiple "Contract types" that use the same value "M, T, G or H"
I could see if the type was tied using RECID, but it appears to be tied using a value that is not unique... I must be misunderstanding how these relationships are created/managed.
Any help would be appreciated.
Comment