PC_SR_SUM_DTL

(SQL Table)
 Index Back

Status Report Summary Detail

Status Report Summary Detail record

  • Parent Record Of PC_SR_SUMDTL_AF SR_SUM_DTL_AF

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

    Prompt Table: PERSONAL_DATA

    2 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

    Default Value: OPR_DEF_TBL_PC.BUSINESS_UNIT

    Prompt Table: PC_SR_BU_VW

    3 PROJECT_ID Character(15) VARCHAR2(15) NOT NULL Project Id ChartField

    Default Value: OPR_DEF_TBL_PC.PROJECT_ID

    Prompt Table: PGM_SR_PROJ_VW

    4 SR_START_DATE Date(10) DATE NOT NULL Status Report start date

    Prompt Table: PC_SR_STRTDT_VW

    5 SR_END_DATE Date(10) DATE Status Report end date
    6 ACTIVITY_ID Character(15) VARCHAR2(15) NOT NULL Activity ID

    Prompt Table: PC_SR_ACTIV_VW

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

    Prompt Table: PC_SR_PJROLE_VW

    8 NAME Character(50) VARCHAR2(50) NOT NULL Name

    Prompt Table: PERSONAL_DATA

    9 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    10 COMMENTS_2000 Long Character CLOB Comment Text
    11 SR_ISSUES_FLAG Character(1) VARCHAR2(1) NOT NULL Status Report issues flag
    12 SR_COMPLETE_FLAG Character(1) VARCHAR2(1) NOT NULL Complete Flag
    N=No
    Y=Yes

    Default Value: N

    13 FMS_DTTM_STAMP DateTime(26) TIMESTAMP Specifies the date and time of the original entry.
    14 FMS_OPRID Character(30) VARCHAR2(30) NOT NULL Specifies the User ID which made the original entry.
    15 FMS_LASTUPDDTTM DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry.
    16 FMS_LASTUPDOPRID Character(30) VARCHAR2(30) NOT NULL Specifies the User ID which made the last update to an entry.