GM_ACTIV_LINES

(SQL Table)
 Index Back

  • Parent Record Of GM_ACTIVLN_SBR

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
    2 PROPOSAL_ID Character(25) VARCHAR2(25) NOT NULL Proposal ID
    3 VERSION_ID Character(7) VARCHAR2(7) NOT NULL Version ID
    4 SUB_PROP_NBR Character(15) VARCHAR2(15) NOT NULL SUB_PROP_NBR
    5 BUDGET_ID Character(15) VARCHAR2(15) NOT NULL BUDGET_ID
    6 BUDGET_PERIOD_GM Number(3,0) SMALLINT NOT NULL BUDGET_PERIOD_GM
    7 BUDGET_LN Number(6,0) INTEGER NOT NULL BUDGET_LN
    8 SEQ_NUM Number(3,0) SMALLINT NOT NULL Sequence
    9 JOBCODE Character(6) VARCHAR2(6) NOT NULL Job Code

    Prompt Table: PC_RATE_JOBC
    Set Control Field: BUSINESS_UNIT_PC

    10 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    11 QTY_INTEGER Number(11,0) DECIMAL(11) NOT NULL Quantity Rounded to 0 Decimals

    Default Value: 1

    12 BEGIN_DT Date(10) DATE Begin Date
    13 END_DT Date(10) DATE End Date
    14 NBR_OF_HOURS Number(5,0) INTEGER NOT NULL Number of Hours
    15 QTY_X_HOURS Number(11,0) DECIMAL(11) NOT NULL Quantity * Hours
    16 NBR_OF_DAYS Number(5,0) INTEGER NOT NULL Number of Days
    17 WEEKLY_WEEKS Number(3,0) SMALLINT NOT NULL Weeks
    18 QTY_X_WEEKS Number(11,0) DECIMAL(11) NOT NULL Quantity * Weeks
    19 STD_BILL_RATE Number(27,3) DECIMAL(26,3) NOT NULL Standard Bill Rate

    Default Value: 0

    20 ADJUSTED_FLAG_BILL Character(1) VARCHAR2(1) NOT NULL Adjusted Flag
    H=Header Level Adjustment
    L=Line Level Adjustment
    N=No Adjustments

    Default Value: N

    21 ADJUST_OPTION_BILL Character(1) VARCHAR2(1) NOT NULL Adjustment Option Bill Rate
    A=Flat Amount
    N=No Adjustment
    P=Percentage
    R=New Rate

    Default Value: N

    22 ADJUSTMENT_BILLAMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Adjustment Bill Amount
    23 ADJUSTMENT_BILLPCT Signed Number(7,2) DECIMAL(5,2) NOT NULL Adjustment Bill Percent
    24 ADJUSTMENT_BILL_RT Number(27,3) DECIMAL(26,3) NOT NULL Adjustment Bill Rate
    25 ACTUAL_BILL_RATE Number(27,3) DECIMAL(26,3) NOT NULL Actual Bill Rate
    26 STD_COST_RATE Number(27,3) DECIMAL(26,3) NOT NULL Standard Cost Rate

    Default Value: 0

    27 ADJUSTED_FLAG_COST Character(1) VARCHAR2(1) NOT NULL Adjusted Flag
    H=Header Level Adjustment
    L=Line Level Adjustment
    N=No Adjustments

    Default Value: N

    28 ADJUST_OPTION_COST Character(1) VARCHAR2(1) NOT NULL Adjustment Option Cost Rate
    A=Flat Amount
    N=No Adjustment
    P=Percentage
    R=New Rate

    Default Value: N

    29 ADJUSTMENT_COSTAMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Adjustment Cost Amount
    30 ADJUSTMENT_COSTPCT Signed Number(7,2) DECIMAL(5,2) NOT NULL Adjustment Cost Percent
    31 ADJUSTMENT_COST_RT Number(27,3) DECIMAL(26,3) NOT NULL Adjustment Cost Rate
    32 ACTUAL_COST_RATE Number(27,3) DECIMAL(26,3) NOT NULL Actual Cost Rate
    33 BILL_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Bill Amount
    34 COST_AMT Number(27,3) DECIMAL(26,3) NOT NULL Cost Amount
    35 PM_MARGIN_PCT Signed Number(7,2) DECIMAL(5,2) NOT NULL Margin Percent
    36 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

    Default Value: GM_PROPOSAL.CURRENCY_CD

    37 RS_RESRC_TEMPLT_ID Character(10) VARCHAR2(10) NOT NULL Resource Template ID

    Prompt Table: RS_RESRC_TMP_VW

    38 PROJ_ROLE Character(15) VARCHAR2(15) NOT NULL Project Role

    Prompt Table: RS_PROJROLE_VW

    39 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

    Prompt Table: PC_RATE_EMPL

    40 REVIEW Character(1) VARCHAR2(1) NOT NULL Review
    41 RES_RATE_FLG Character(1) VARCHAR2(1) NOT NULL Resource Rate
    E=Employee ID
    J=Job Code
    R=Role Type

    Default Value: J

    42 NOTE Long Character(256) VARCHAR2(256) Note